Skip to main content
Solved

Error in calculations from numbers derived from rollup


Forum|alt.badge.img+4

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

Best answer by TheTimeSavingCo

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

({FIELD NAME} + 0)

Link to base

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+13

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


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • August 9, 2024
Alyssa_Buchthal wrote:

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


It's an Array


Forum|alt.badge.img+13
Angelo_Blot1 wrote:

It's an Array


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


TheTimeSavingCo
Forum|alt.badge.img+28

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

({FIELD NAME} + 0)

Link to base


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • August 10, 2024

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