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%

Prajjwal88

Hi @IvyXu ,

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

1. 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:
   
   
2. 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! 😀