Skip to main content

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

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


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


It's an Array


It's an Array


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


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

({FIELD NAME} + 0)

Link to base


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 🙏

 


Reply