Adjusting a formula

Hi, I am currently working on creating a P/L where we multiply a item by a certain percentage. To get this percentage, I had to create a another module and use past actual data to arrive at the %.

The issue is now In my module of calculating the % . FY19 is the percentage I need to bring over to my P/L but everything I have tried doesnt seem to be able to bring in only FY19 %

Accepted answers

anirudh

Glad that it worked!!

To remove hardcoding is acually very easy. Just create a module with no dimensions and a line item for the year selection (Format : Year) then edit your formula to say:

'Module 2'.Percentage line item[Lookup: Module.Year selection]

Then set the line item manually to FY19

Regards,
Anirudh

All comments

Misbah

@ciara

Usually we use OFFSET function to pull past years value but if you can post a snapshot of your module we shall be in a better position to help you

Misbah

anirudh

Hi ciara,

Are you trying to refer the year value from a module dimensioned with months?
Try this:
'Module 2'.Percentage line item[SELECT: Time.'FY 19']
It's best practice to avoid hardcoding formulas with select function, but let me know if this works first and we can remove the hardcoding later

Regards,
Anirudh

ciara

Thank you so much, While its not ideal to hardcode FY19, its better then not having the correct %. Thanks 🙂

anirudh

Then set the line item manually to FY19

Regards,
Anirudh

Quick Links

Can you help?

Unanswered questions

Can Please explain the difference between a general list,a module,and action in Anaplan.
Can please explain why we create a general list ,a module,and Action ,and what purpose each one serves.🙂
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.…