Skip to main content

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?


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:



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:




Found it! Thanks a lot!

Reply


Terms & Conditions