9.2.6 Activity: Add Formulas to Margin Calculation Module

Tanok
Tanok
in Modeling

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

Tagged:

Best Answer

  • abhi1017
    abhi1017
    Answer ✓

    @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

     

     

Answers

Categories