9.2.6 Activity: Add Formulas to Margin Calculation Module
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
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.
Try changing SYS Zero Zero to SYS OO (Capital O, Capital O).0