Level 2 Sprint 3 Confirm PO

roblund
roblund
in Modeling

Season's greetings all.

 

I am completely at a loss. My final confirm PO equation, after several iteration, is as follows;

 

IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks)ELSE 0

 

Is there a logic context error here somewhere that I am overlooking?  Any help would be greatly appreciated. Thank you.

Tagged:

Comments

  • jczimbal
    jczimbal

    You are very very close. Look at the following (Formulas section):

     

    https://community.anaplan.com/t5/Chapter-2/tkb-p/Chapter2Planual#formulas

     

    Think about having Anaplan doing the calculation quickly (for the majority of the instances).

  • roblund
    roblund

    Thank you.  Let me review again. I think that I may have it figured out based off of your feedback. I will let you know.  

  • roblund
    roblund

    Is this a Performance refinement to better align with PLANS?  If so, then does the following meet the requirement?

     

    IF Confirmed PO Delivery < 1 THEN 0 ELSE POST(Final Shipment Amount, Final Shipping Time Weeks)

     

    Kind regards,

    Rob

  • jczimbal
    jczimbal

    I can't give you the final answer but just think about the values that you are comparing within the 'Confirmed PO Delivery', i.e. what possible values this line item can hold (coming from 'PO Submitted'). It's better to be more precise in IF/THEN/ELSE formulas.

  • roblund
    roblund

    Silly oversight on my part! Got it!  Thank you again.

Categories