Need Averages of months of prior years

krishnadbr

Hi All,

 

I have a situation where I need to get  Average value of total sales in Jan17, Jan18, Jan19, Jan20 and Jan21 to be projected into Jan22 in a module. Please can anyone suggest how can I achive this.

 

Thanks,
Balarama Krishna

KirillKuznetsov

@krishnadbr 

LAG(<source LI>,12,0)+LAG(<source LI>,24,0)+ LAG(<source LI>,36,0)+ LAG(<source LI>,48,0)....

You got the idea 🙂

krishnadbr

@KirillKuznetsov 

 

Thanks to you.