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

DJSISON
Occasional Contributor

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

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

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
DJSISON
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 ?

View solution in original post

JaredDolich
Moderator

@DJSISON 

Make sure your context selectors are at the lowest level. That will allow you to change the value.


Jared Dolich

View solution in original post

5 REPLIES 5
rishabh01
Frequent Contributor

Hi @DJSISON

Data in FY20 and FY21 is also populating because you have entered 0.05 in the formula bar of unit cost% line item. Doing this populates each cell of that line item with the value entered in the formula bar.

To populate just FY19, first clear the formula bar and then click on FY19 cell of unit cost% and enter 5 there, in this way it will only populate FY19 cell only.

And, to enter 5% in the cell, you just have to write 5.

Hope this helps,

Rishabh.

 

DJSISON
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

 

rishabh01
Frequent Contributor

Hey @DJSISON 

When you enter the numeric value in the formula bar it converts it to the %, hence 5 become 500%, but when you enter the values in the individual cells it keeps it as % so if you enter 5 in a particular cell it will accept it as 5%.

Try doing it yourself.

NOTE: You want 5% in FY19 cell only, but you are entering the value in the formula bar, instead enter the value in the cell under FY19 of unit cost% line item.

Thanks,

Rishabh.

DJSISON
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 ?
JaredDolich
Moderator

@DJSISON 

Make sure your context selectors are at the lowest level. That will allow you to change the value.


Jared Dolich