Help

Value function returning Error

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

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:

  1. Within the formula of the Rollup, try VALUE(ARRAYUNIQUE(values))
  2. 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!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Can you post a screen shot? If you are rolling up a number field, you should not be getting a string with the formulas you have posted. Instead, you may be getting an array of numbers (even if it looks like a single number).

Try this formula in the rollup …

MAX(ARRAYUNIQUE(values))

or this formula …

VALUE(ARRAYJOIN(ARRAYUNIQUE(values), "")

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Can you post a screen shot? If you are rolling up a number field, you should not be getting a string with the formulas you have posted. Instead, you may be getting an array of numbers (even if it looks like a single number).

Try this formula in the rollup …

MAX(ARRAYUNIQUE(values))

or this formula …

VALUE(ARRAYJOIN(ARRAYUNIQUE(values), "")
oceanseleven11
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi kuovonne,
Many thanks for your help, MAX function worked it out!
No idea why that worked - and not VALUE - but I’ll remember the trick :winking_face:
Have a nice day!