
Partner - Contributor III
2023-09-19
05:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If function with division expression
This is my current calculation:
column(7)/column(11)
Usually I would utilize an if statement like this:
If (column(7)/column(11)>0,column(7)/column(11),'')
Which would show all available numbers over 0. However this expression doesn't work as expected.
So was wondering if it is possible to achieve something similar with a different approach.
Thankyou
449 Views
1 Reply


MVP
2023-09-19
05:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Instead an if-loop you may try something like:
rangemax(column(7)/column(11), 0)
437 Views
