Hi beloved Airtable Community!
I’ve got an issue with a VALUE formula.
I have a Rollup field that does a ARRAYUNIQUE job from a Lookup Field which is formatted as a % (i.e. 36%).
The output I get from the Rollup field is a string (i.e. 0.357142852346992).
I tried various ways to convert it back to a number like:
- Within the formula of the Rollup, try VALUE(ARRAYUNIQUE(values))
- Create a new formula field that performs VALUE(ROLLUP FIELD)
But both outputs give me “#ERROR”
I’ve read some articles about VALUE behavior but not sure to understand how it might help in that particular case.
Would you have any hints?
Thanks a lot, appreciate it!