# ARRAYUNIQUE to number

Topic Labels: Formulas
Solved
Jump to Solution
990 2
cancel
Showing results for
Search instead for
Did you mean:
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
18 - Pluto

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:

2 Replies 2
18 - Pluto

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:

5 - Automation Enthusiast

Found it! Thanks a lot!