LM1B 9.2.6

Yogitha
Frequent Contributor

LM1B 9.2.6

2022-08-27.png2022-08-27 (3).png2022-08-27 (2).png2022-08-27 (1).pngcarryforward problem

7 REPLIES 7
JaredDolich
Moderator

@Yogitha 

Formula is correct. What error are you getting?


Jared Dolich
Yogitha
Frequent Contributor

5.00% is not getting carryforwarded
Yogitha
Frequent Contributor

Expected: 

this screenshot is part of activity, where unit price growth % has a formulathis screenshot is part of activity, where unit price growth % has a formulaHere, there is no formula . So shd i add a formula?    formula from REV04 did not get carryforwarded to rev03Here, there is no formula . So shd i add a formula? formula from REV04 did not get carryforwarded to rev03

RavinderB
Regular Contributor

@Yogitha 

 

Hi 

 

You have put your IF formulas in the wrong line items 

 

They belong in the unit cost and unit price % lines

 

You also will need to correct and use the right formulas for margin and margin %

 

Please refer to the activity again for guidance

 

Thank you 

 

Ravinder 

 

 

 

 

 

 

 

 

 

Yogitha
Frequent Contributor

can u please check, I changed the formulas

the value 5.00% is not getting carryforwarded2022-08-27 (7).png

RavinderB
Regular Contributor

@Yogitha 

 

What are the 2 formulas in full for unit price growth % and unit cost growth %?

 

Remember you should input a % in price growth module for a detail value eg US and chocolates, and see the 5% in the price growth staging module in the related values, and see the 5% in the margin calc module; only in yr 20 or 21

 

Thank you 

 

Ravinder 

 

 

Yogitha
Frequent Contributor

Here are the for formulas:

I 2022-08-28 (1).png2022-08-28.pngtried all of it , not able carryforward it to REV03