
Creator
2021-06-10
06:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count only if another field's value is less than 1
Hi
Quite a simple one.
I just want to create a KPI that displays the count of Stockpiles where the Tonnage isn't 0 (or Less than 1)
Example
Stockpile | Tonnage |
1 | 23 |
2 | 0 |
3 | 21 |
4 | 0 |
5 | 54 |
6 | 21 |
So the answer I'm looking for is 119.
Thanks in advance
- Tags:
- if
1 Reply

MVP
2021-06-10
06:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=sum({<Tonnage={">0"}>}Tonnage)
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
717 Views
