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.
LAG(<source LI>,12,0)+LAG(<source LI>,24,0)+ LAG(<source LI>,36,0)+ LAG(<source LI>,48,0)....
You got the idea 🙂
Thanks to you.