I need the correct formula to count the items from a Get items, I need to count those records where Days is greater than 0.
I have a variable TotCount with the he expression:
The above code always returns 0, below are a few example of what I need:
TotCount = 2
TotCount =5
TotCount =4
I have a variable TotCount with the he expression:
Code:
if(greater(item()?['Days'], 0), 0, 1)
The above code always returns 0, below are a few example of what I need:
| Days |
| 1 |
| 0 |
| 5 |
| Days |
| 1 |
| 22 |
| 3 |
| 7 |
| 12 |
| Days |
| 1 |
| 0 |
| 3 |
| 7 |
| 12 |