POST formula in SPRINT 3

CCC
New Contributor
New Contributor

POST formula in SPRINT 3

Hello,

 

Can someone help me to understand why for "Confirm Purchase Order Receipt" line Item, "POST(IF NOT Submit Purchase Order Request? THEN 0 ELSE Final Shipment Amount, Final Shipping Time Weeks) " is not a correct answer for the formula to use?

 

Regards

4 REPLIES 4
KirillKuznetsov
Certified Master Anaplanner

Re: POST formula in SPRINT 3

The order of the output for IF THEN ELSE looks thoughtfull. Nothing to add here.

Probably they wanted you to split the formula into two line items: IF THEN ELSE and POST.

ChrisHeathcote
Community Boss

Re: POST formula in SPRINT 3

@CCC Nesting the IF THEN ELSE within the POST function doesnt look right!

Start the IF with the query 'NOT Submit Purchase Order Request?' then close out the ELSE with the POST function.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
CCC
New Contributor
New Contributor

Re: POST formula in SPRINT 3

Actually, the formula works since I get the result they put in the screenshot. I thought I followed DISCO recommandation about using booleans in comparisons instead of numbers. Also, it is more easier for me to understand that the amount we push depends on whether or not a Purchase Order Request is submitted.

 

@ChrisHeathcote  when you say "doesn't look right" you mean on DISCO point of view?

ChrisHeathcote
Community Boss

Re: POST formula in SPRINT 3

I can see how the formula returns the correct answer but the in my view is not structured logically. Therefore, it's more about PLANS rather than DISCO.


The IF THEN ELSE is a query that determines whether to use the POST formula or not based on the outcome of a specific condition. 

 

Therefore, state a criteria and then the outcomes for a true and false result.

 

I would also break out the query to a separate boolean formatted line item and use this in the downstream IF THEN ELSE. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA