
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 09, 2024 08:00 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 09, 2024 07:17 PM
Try wrapping the field that's giving you problems like so:
({FIELD NAME} + 0)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 09, 2024 09:52 AM
What is your roll-up function? Is it summing, or is it an array function?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 09, 2024 10:07 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 09, 2024 11:09 AM
So what are you expecting to happen when you multiply an array by a number?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 09, 2024 07:17 PM
Try wrapping the field that's giving you problems like so:
({FIELD NAME} + 0)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 10, 2024 01:17 AM
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 🙏
