Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Re: ARRAYUNIQUE to number

Solved
Jump to Solution
71 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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:

See Solution in Thread

2 Replies 2

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: