Error in calculations from numbers derived from rollup

[Angelo_Blot1]

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

[Alyssa_Buchthal]

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

[Angelo_Blot1]

It's an Array

[Alyssa_Buchthal]

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

[TheTimeSavingCo · Accepted solution]

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

({FIELD NAME} + 0)

Link to base

 

[Angelo_Blot1]

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 🙏