Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an expression that makes the cumulative calculation of 12 months, but need a similar analysis that always disregard the first two months of a contract and start to accumulate from the third month as shown below in the yellow column..
This is the expression to 12 months (Green column):
aggr(rangesum(above(sum({$<MONTH_YEAR,YEAR>}Val2),0,12)),MONTH_YEAR)
/
aggr(rangesum(above(sum({$<MONTH_YEAR,YEAR>}Val1),0,12)),MONTH_YEAR)
Thanks!
Thank You!
This part of the document solved my problem.
sum({<Month={'>=$(=max(Month)-2)<=$(=max(Month))'}>}Amount)
You could do it with an AsOf table like described in this document: Calculating rolling n-period totals, averages or other aggregations
PFA
expression used: =Rangesum(Above(If(RowNo() > 2, Val2, 0),0,12))/Rangesum(Above(If(RowNo() > 2, Val1, 0),0,12))
Best,
S
Thank You!
This part of the document solved my problem.
sum({<Month={'>=$(=max(Month)-2)<=$(=max(Month))'}>}Amount)
Thanks. It works great, too.