about sum functon ho we can get the data last from 6 months actuals?

You should consider using a real timescale, will help a lot if you need to do such time based calculations. However, you could create a mapping module, to map your custom time to real time, lookup the data on a real timescale so you can use Time based formulas.
Or a simple and performant way to get this value would be to create a 6 month subset in your custom time list and reference the Actuals with an Average summary option set for the line item (assuming you have a top level).

Sampriti.Anand

Hi @kavitha12345 ,

I have created a module Test Time where the actuals data of the past three years is stored. I have created another module Test Time - Copy where I have created a line item to derive the last 6 month from the current month and then using lookup the values from Test Time module have been fetched into Test Time Copy. I have used Custom Time Ranges in both the modules. A similar approach will be of help to you.

Thanks!

kavitha_potturu

Thanks

ChrisAHeathcote

An alternative is to map your custom time to real time. Then map your data out of custom time into a module dimensioned by real time. Use this to calculate your MOVINGSUM() then map it back to custom time use the same mapping.

The actual real timescale is not important but it is vital that you map into real time and back out to custom time using the same logic.

The use of real time is simply to use all available time functions.

However, if you can avoid using custom time altogether then I would also recommend that you do so.

Amaya

Hi @kavitha12345 ,

You have to use the Model Calendar, as everyone says.

I think you can do this, but it will be complex and ****.

CAUTION! So do not take the below seriously.

Module Module Grid Grid

Taichi

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385