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

Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
ADO Module Saved View does not exist Error
Hi, I’m experiencing a strange issue in ADO that I can’t seem to resolve. Before reaching out to Anaplan Support, I thought I would check with the community for advice. I’m trying to extract some list properties for an ADO mapping from a Polaris model/module. However, no matter what I do, I keep encountering the same error…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…