YTD Cumulative with zero values

[Anonymous]

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

[sunny_talwar]

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