9.2.6 Activity: Add Formulas to Margin Calculation Module

Options
Tanok
Tanok Member, ALL USERS, GroupMember, Community Member Posts: 3 Occasional Contributor
in Planning & 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:

Comments

  • Tanok
    Tanok Member, ALL USERS, GroupMember, Community Member Posts: 3 Occasional Contributor

    Hello @abhi,
    Here is the screenshot:

    Tanok_0-1621406965464.png

     

    Tanok

  • SteveHoneycutt
    SteveHoneycutt Member, ALL USERS Posts: 1 New Contributor

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

Categories