ARRAYUNIQUE to number

[Caesar_Ivarsson]

I use ARRAYUNIQUE in a Rollup to show the latest number for a field in another table.
That field is a percentage field (I could make it numeric too, no problem)

The percentage/number in the original field is possible to format neatly with 2 decmals.

However the rollup ARRAYUNIQE (values) is showing all the decimals, which looks crap to be honest.
But since it’s not numbers anymore, is there a way to make it look prettier?

Right now my solution (which doesn’t work) was to make a new formula field and do this: "IF( {roll copy} = 0, BLANK(), "% "& ({roll copy} “show only two decimals”) )

Do you get what I’m looking for?

[ScottWorld · Accepted solution]

Caesar_Ivarsson:

I use ARRAYUNIQUE in a Rollup to show the latest number for a field in another table.

ARRAYUNIQUE will return an array of strings, and is not the way to show the latest number for a field in another table.

To show the latest number for a field in another table, you should use the trick that I outline in this episode of the BuiltOnAir video podcast:

[Caesar_Ivarsson]

Found it! Thanks a lot!