Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I need a set analysis calculation Cumulative value YTD with zero values. Here is de sample dataset and how is calculated. When selecting on the time field this shouldn't be changing. The cumulative starts again after one year...
pls advice thanks!
Robbie
Time | Value | Cumulative value YTD |
jan-16 | 10 | 10 |
feb-16 | 11 | 21 |
mrt-16 | 16 | 37 |
apr-16 | 80 | 117 |
mei-16 | 0 | 117 |
jun-16 | 0 | 117 |
jul-16 | 90 | 207 |
aug-16 | 5 | 212 |
sep-16 | 60 | 272 |
okt-16 | 4 | 276 |
nov-16 | 5 | 281 |
dec-16 | 8 | 289 |
jan-17 | 80 | 80 |
feb-17 | 75 | 155 |
If those values are not missing, you can try this:
Aggr(RangeSum(Above(Sum(Value), 0, RowNo())), YearField, Time)
Make sure to replace YearField with Year field in your database