Need Averages of months of prior years

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

Accepted answers

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 🙂

All comments

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.

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…