Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=sum({<Tonnage={">0"}>}Tonnage)