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

Level 3 - DAT02 PY Revenue to CY
Hello all experienced MB's Created a Module to Pull PY revenue to CY, Module has dimensions A2 Account>Product# and G2 Country. Whatever country I select the value shown is for ALL regions This is something to do with aggregations, but I'm struggling to figure out which is correct, surely SUM is incorrect. Any suggestions?…
Selection of multiple option from list on UX pages
Hello Anaplaner, Please find the attached Excel sheet along with the use case description below. We have a use case where the end user requires a selection option on the UX page from a list (Product & Company). As you may be aware, there is currently no option available on the UX page to select multiple list members from a…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…