Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm trying to do the cumulative by year, but when start a new year, is continue cumulating but I want to start a new cumulative when a new year start.
my expression:
aggr(rangesum(above(Sum( value),1,RowNo())),(year_month,NUMERIC))
I dont understand why, jan 2022 is not start a new cumulative, its keeping cumlating. Someome please help me?
The expected result is that in jan 2022, the value to third column be 996766,42 starting a new cumulative values
@sunny_talwar please help me
try as below
=aggr(rangesum(Above(sum(value),0,rowno())),YEARFIELD,YEARMONTHFIELD)
First of all thank you for your answer..
But not working
aggr(rangesum(below(sum({<period-={'$(=min({1}period))'}>}[value]),0,rowno())),period,period_2)