nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

IvyXu

In this activity, 1st step is Add Formulas to REV05 Price Growth Rates Staging Module, I did it in REV05, and then based on the instruction, I need to enter 5% for the FY19 Unit Cost% in REV04, but i didn't find way to input the 5%

Accepted answers

Prajjwal88

Hi @IvyXu ,

There are two key things that need to be corrected for the required Input:

Subsidiary View Issue:
From your screenshot, I can see that the line items Unit Price% and Unit Cost% have a subsidiary view (indicated by the icon next to the line item name). This means their dimensions are different from the module’s main dimensions.
To fix this, go to Blueprint View, and in the Applies To and Time Scale columns for those line items, make sure they are set to match the module. If you want them to follow the module’s default dimensions, simply enter a dash (-) for Applies To and select the respective Time format from Time Scale which is year. Refer to attached Screenshot:
How to Input 5% for FY19:
The input should be made at a specific intersection i.e., for one Product, one Country, and FY19. You need to double-click directly into the cell for FY19 under the appropriate product and country combination to enter 5%.
Do not try to enter the value from the formula bar; doing that applies the same value across all periods and dimensions, which is not what’s needed here. Refer to the instructions to identify the right cell intersection. The reason currently It's not letting you apply the same is the "%" symbol. The line item format is number hence only numerical figures can be putted in the formula bar.
(Note that you can set the percentage representation by going to line item format and choosing the correct decimal places and Unit as percentage)

The below snapshot shows the wrong Input made from formula bar:

Hope this helps! 😀

All comments

Prajjwal88

Hi @IvyXu ,

Based on the screenshots from your model, I can see that the input value (5%) in REV04 has already been entered as required (If that's not the case then please share more information/ snapshot of your REV04 module). The next step is to validate whether this value flows correctly into REV05 using the formula you've applied; which I can also see is working as expected. If there's anything else you can share screenshots from your build to make the ask more clear.

IvyXu

Hi @Prajjwal88,

the screenshot you saw in my last post is the instructions from the academy learning course, which requires me to input 5% in the FY19 Unit Cost%, however I don't know how to do that, I tried to input 5% in the Edit, but it doesn't allow me to apply

Prajjwal88

Hi @IvyXu ,

There are two key things that need to be corrected for the required Input:

Subsidiary View Issue:
From your screenshot, I can see that the line items Unit Price% and Unit Cost% have a subsidiary view (indicated by the icon next to the line item name). This means their dimensions are different from the module’s main dimensions.
To fix this, go to Blueprint View, and in the Applies To and Time Scale columns for those line items, make sure they are set to match the module. If you want them to follow the module’s default dimensions, simply enter a dash (-) for Applies To and select the respective Time format from Time Scale which is year. Refer to attached Screenshot:
How to Input 5% for FY19:
The input should be made at a specific intersection i.e., for one Product, one Country, and FY19. You need to double-click directly into the cell for FY19 under the appropriate product and country combination to enter 5%.
Do not try to enter the value from the formula bar; doing that applies the same value across all periods and dimensions, which is not what’s needed here. Refer to the instructions to identify the right cell intersection. The reason currently It's not letting you apply the same is the "%" symbol. The line item format is number hence only numerical figures can be putted in the formula bar.
(Note that you can set the percentage representation by going to line item format and choosing the correct decimal places and Unit as percentage)

The below snapshot shows the wrong Input made from formula bar:

Hope this helps! 😀

Quick Links

Can you help?

Unanswered questions

Anaplan Analyst performance on large, sparse models
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…