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
Best Answer

Please refer the lineitems directly from the respective modules rather copypasting 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 copypasted.
~ABhi
1
Comments

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