9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

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

3.3.12 Activity: Create Product Replenishment UX Page
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom view…
How to represent in Anaplan an organizational structure
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
ADO Certification - Cannot Create Migration Link
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?