Level 1 - 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

Options
DJSISON
DJSISON Member, ALL USERS Posts: 4 Occasional Contributor
in Anaplan Community

Hi,

After adding the formula for the Unit Price% and Unit Cost%

When the activity asked to enter 5.0% for the FY19 Unit Cost%.

It also populates the FY2O and FY21 at 5.0% too. 

Also, how do you enter the 5% in the cell .05?

How can I fix this?

 

DJSISON_0-1658060127408.png

 

 

Tagged:

Comments

  • DJSISON
    DJSISON Member, ALL USERS Posts: 4 Occasional Contributor

    Hi Rishabh01,

     

    Appreciate your assistance and time.

     

    Though, the reason why I typed .05 because when I type 5 in the cell it goes to 500%.

     

    DJSISON_0-1658066893606.png

     

  • DJSISON
    DJSISON Member, ALL USERS Posts: 4 Occasional Contributor
    Hi rishabh01,

    Once again, Thank you.

    It doesn't let me enter the numeric item in the cell.
    Is there anything I have to fix in Grid view ?
  • fabianmp
    fabianmp Member, ALL USERS Posts: 3 Occasional Contributor

     

     

    Hi,

    I'm doing the activity but I entered 5% and the model calculate 60% 

    Can anyone please tell me how to fix it?

    fabianmp_0-1662293800166.png

     

  • fabianmp
    fabianmp Member, ALL USERS Posts: 3 Occasional Contributor

     

     

    Hi,

    I'm doing the activity but I entered 5% and the model calculate 60% 

    Can anyone please tell me how to fix it?

    fabianmp_0-1662381682748.png

     

  • RavinderB
    RavinderB Member, ALL USERS, GroupMember, Employee, Certified Model Builder Posts: 5 Regular Contributor

    @fabianmp 

     

    Do you have summary setting for these line items? They should be set to none.

     

    You also have subsidery views for these items on (small grid icons in image in each line items). These do not have any subsidery views enabled. You probably have dimenions for each line item that are different to the module. 

    Please check.

    There should be no subsidery views for this module.

     

    Thank You

     

    Ravinder.

  • fabianmp
    fabianmp Member, ALL USERS Posts: 3 Occasional Contributor

    It works,

    thanks Ravinder. 

     

    I had the summary for each line and the grids were because the time scale for each line were different from the module.

     

    Thanks for your help.

     

Categories