Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I learned from the great explanation of gwassenaar here in Calculating rolling n-period totals, averages or other aggregations
how i'm ablet to calculate the value per month of the previous 3 months.
But what if I want to calculate the value per month of the following 3 months?
Someone could help me?
Here attached my example.
Thank u all.
Filiberto
Potentially yes, you probably would just need to use below() instead of above() inter record chart function.
There shouldn't be a fundamental difference if you want to look ahead in time, maybe just adapt the AsOfMonth Month field calculation (taken from the original doc):
AsOfMonth:
load
Month as Month_AsOf,
Month + (IterNo()-1) as Month
Resident SalesData
while IterNo() <= 3;
Do u think that it's possible using even the rangesum-aggr combination? swuehl
Potentially yes, you probably would just need to use below() instead of above() inter record chart function.