Register

Level 2 Sprint 3 Confirm PO

roblund
Occasional Contributor

Level 2 Sprint 3 Confirm PO

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.

5 REPLIES 5
jczimbal
Occasional Contributor

Re: Level 2 Sprint 3 Confirm PO

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
Occasional Contributor

Re: Level 2 Sprint 3 Confirm PO

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
Occasional Contributor

Re: Level 2 Sprint 3 Confirm PO

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
Occasional Contributor

Re: Level 2 Sprint 3 Confirm PO

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
Occasional Contributor

Re: Level 2 Sprint 3 Confirm PO

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