## 9.2.6 Activity: Add Formulas to Margin Calculation Module

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.

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
Super Contributor

## Re: 9.2.6 Activity: Add Formulas to Margin Calculation Module

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

4 REPLIES 4
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

Occasional Contributor

## Re: 9.2.6 Activity: Add Formulas to Margin Calculation Module

Hello @abhi,
Here is the screenshot:

Tanok

Super Contributor

## Re: 9.2.6 Activity: Add Formulas to Margin Calculation Module

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

New Contributor

## Re: 9.2.6 Activity: Add Formulas to Margin Calculation Module

Try changing SYS Zero Zero to SYS OO (Capital O, Capital O).