9.2.6 Activity: Add Formulas to Margin Calculation Module

Tanok
Occasional Contributor

9.2.6 Activity: Add Formulas to Margin Calculation Module

Hello, 

May I get help with this part. I tried to add formulas to these line items but it does not work". There is an error each time.

Tanok_0-1621401025045.png

Unit Price Growth: IF 'SYS00 Time Settings'.Forecast Period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Unit Price %) ELSE 0

Unit Cost Growth %: IF 'SYS00 Time Settings'.Forecast Period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Unit Cost %) ELSE 0

1 ACCEPTED SOLUTION

Accepted Solutions
abhi1017
Super Contributor

Re: 9.2.6 Activity: Add Formulas to Margin Calculation Module

@Tanok 

 

Please refer the lineitems directly from the respective modules rather copy-pasting formulas from the course content as:-

1. This may avoid syntax errors.

2. You will have a better understanding of the application of the functions/formulas.

3. You may find some missing pieces of the formulas which are not available in the model. Such missing pieces lead to errors when formulas are copy-pasted.

 

~ABhi

 

 

View solution in original post

3 REPLIES 3
abhi1017
Super Contributor

Re: 9.2.6 Activity: Add Formulas to Margin Calculation Module

hi @Tanok 

 

Could you please share screenshot of the error to hep you better.

 

 

~ABhi

Tanok
Occasional Contributor

Re: 9.2.6 Activity: Add Formulas to Margin Calculation Module

Hello @abhi,
Here is the screenshot:

Tanok_0-1621406965464.png

 

Tanok

abhi1017
Super Contributor

Re: 9.2.6 Activity: Add Formulas to Margin Calculation Module

@Tanok 

 

Please refer the lineitems directly from the respective modules rather copy-pasting formulas from the course content as:-

1. This may avoid syntax errors.

2. You will have a better understanding of the application of the functions/formulas.

3. You may find some missing pieces of the formulas which are not available in the model. Such missing pieces lead to errors when formulas are copy-pasted.

 

~ABhi

 

 

View solution in original post