Help

Error in calculations from numbers derived from rollup

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

Hello,

I have a problem performing calculations on numbers from rollup's columns. When I do additions and subtractions, I don't get any errors. However, when I try to do multiplications and divisions, I get an error. I tried adding value() to convert the text to a number (despite the original values being numbers). Although this no longer generates an error, the calculation doesn't work. I was trying to check if the divisor is greater than zero, but despite the tests, it doesn't work.

I need some help 🙏

Thank you,

Angelo

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try wrapping the field that's giving you problems like so:

({FIELD NAME} + 0)

Screenshot 2024-08-10 at 10.17.17 AM.png

Link to base

See Solution in Thread

5 Replies 5
Alyssa_Buchthal
8 - Airtable Astronomer
8 - Airtable Astronomer

What is your roll-up function? Is it summing, or is it an array function?

It's an Array

So what are you expecting to happen when you multiply an array by a number?

TheTimeSavingCo
18 - Pluto
18 - Pluto

Try wrapping the field that's giving you problems like so:

({FIELD NAME} + 0)

Screenshot 2024-08-10 at 10.17.17 AM.png

Link to base

Angelo_Blot1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi !

@Alyssa_Buchthal : Thank you for letting me realize I was playing with an array and not a number

@TheTimeSavingCo : Thank you for giving me a solution

Love this community 🙏