Formula to Select data based on Month

Hi,

I am new to Anaplan.

I would like to have a formula that pulls data from module A if the month is earlier than say Feb 2021 and to extract value from module B if the month is from Mar 2021 onwards. What is the formula to do this please? Thank you.

Accepted answers

LipChean_Soh

Hi @CHSJ

To add to what @jakesachs , you can further enhance the sustainability of the model by creating a reference month that someone (admin pehaps?) can modify.

1. Creating a dynamic reference month makes sense, because you shouldn't modify this formula every month just to change the time check.

2. Creating a SYS Mth module is part of our DISCO methodology, where SYS (short for System) refers to 'S' in 'DISCO'. Essentially you want to create a system module so that the same line item can be referenced by other modules somewhere within the module.

3. Creating a System module obeys the 'Calculate Once, Reference Many times' mantra in 'PLANUAL'.

Good luck on your Anaplan journey.

Thanks,

LipChean

All comments

jakesachs

Hello, your question is a little vague but I think what you need to do is utilize a time settings module with boolean filters. Anaplan provides some time settings apps for you to reference what those modules look like.

Basically you would do a simple IF formula based on that boolean. In your time settings module, you'd have a line item that is checked for every month before Feb 2021 and empty for months after. The formula is 'IF (time setting module line item) then Module A ELSE Module B.

The formula looks at the time settings module line item, if that month is checked then it pulls the value from module A, else it pulls from module B.

LipChean_Soh

Hi @CHSJ

To add to what @jakesachs , you can further enhance the sustainability of the model by creating a reference month that someone (admin pehaps?) can modify.

1. Creating a dynamic reference month makes sense, because you shouldn't modify this formula every month just to change the time check.

3. Creating a System module obeys the 'Calculate Once, Reference Many times' mantra in 'PLANUAL'.

Good luck on your Anaplan journey.

Thanks,

LipChean

CHSJ

Thanks! Will give it a try!

CHSJ

Thanks LipChuan. I am totally new so will have to try it out but it makes alot of sense.

Quick Links

Can you help?

Unanswered questions

Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…