Inserting a formula

New to anaplan platform, i want to insert the formula in my system module and i know we can search it in anaplan anapedia under all functions tab to see which function to apply. But it's not easy to search for a particular line item.

Eg i want to insert formula for years only? boolean formatted line item, so how to find out which formula needs to be inserted?

Accepted answers

paolovm

Wouldn't that be from the training?

From memory as part of the training they would explain how to construct these formulas later on in the material - does that make sense?

Otherwise if it is for a specific use case of yours would be good if you could explain what you're trying to achieve with the line item.

All comments

anirudh

Hi Kunal,

There's quite a number of ways to do a given thing in Anaplan. Over time, you'll learn the most important functions and they will be at your fingertips!
For now, can you share what dimension applies to the subsidiary view (the Years only? line item) in your screenshot and I can help you with the year formula

Regards,
Anirudh

kunal_311

Hi Anirudh,

I had made 9 system modules a few of them but most of them I can't find it, I posted this module for a reference if I can get an away as in how to search or where to look for formulas.

Just to give another example:

I was able to decode the code formula only:

paolovm

Wouldn't that be from the training?

From memory as part of the training they would explain how to construct these formulas later on in the material - does that make sense?

Otherwise if it is for a specific use case of yours would be good if you could explain what you're trying to achieve with the line item.

abhi1017

@kunal_311

As per my understanding of the requirement,

1. SYS01 Time settings by year module should be dimensioned by year (i.e. Change the timescale of the module to year), rather not applicable.

For the below lineitems in Applies to enter "-".

2. For Years only ? - Currentperiodstart() = START()

3. Forecast Years? - START() >= Currentperiodstart()

FYI :-

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/START.html?_ga=2.137674360.9335065.1592136794-746939041.1583986492#

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CURRENTPERIODSTART.html

Try this, Else if you could elaborate the requirement with some more details,can help with the formulas.

~Abhi

NakulAggarwal

Hi @kunal_311

In the first module of time settings if you will use this as filter module and applied the time dimension as time range for Current period, So you just need to activate all boolean by putting True Condition and use them as Filters.

In case you want to achieve this from Model Current Period than you can use below two Formulas

Current Period - CURRENTPERIODSTART() = START()

Forecast period - START() >= Current Period Start

By START function you can achieve the start date and reconcile with the current period of model month start date, If the both are same it will show true.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/START.html

In second you are correctly approaching just that rest of data will come in the training for upload except for few dimension which are parent of the employee list or any other line item. Use Parent Item to get the results.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/PARENT.html

Happy Modeling and welcome to Anaplan.

Thanks,

DavidSmith

Just to add - Years Only? is not a function in itself but the name of the line item

One of the advantages of Anaplan is you can call line item whatever you with with no impact on the rest of the model.

I would also add, that I have the calculation functions bookmarked as there are so many functions available.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/Calculation%20Functions%20TP.htm

So once you are more familiar with the Anaplan concepts are are building on your own before you try and build out the line items take time to think about the problem and check the calculation functions. you might surprise yourself and find a calculation function that does exactly what you want

Remember the Zen of Anaplan - Simple is better than complex

https://community.anaplan.com/t5/Best-Practices/The-Planual/ta-p/49773

Enjoy your Anaplan journey

David

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