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

Accepted answers

All comments

KirillKuznetsov

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.

ChrisAHeathcote

@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.

CCC

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.

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

ChrisAHeathcote

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.

turnerth

I am having the same issue. If you structure the statement like:

Submit Purchase Order Request?

THEN

POST(Final Shipment Amount, Final Shipping Time Weeks)

ELSE

In the target period you will get 0 or the wrong value (if Submit Purchase Order Request?=true) the as it re-evaluates the If again in the current period. I agree, with the OP, I came up with the same solution, it worked, and looks elegant to me, can someone please provide more insight? I have stumped all the Anaplaners in my org with this issue and none of them get it.

Quick Links

Can you help?

Unanswered questions

Can we disable Create page button from the UX page
I want to disable the [create page] button for the end user from the dashboard. The end user can create a page or worksheet to link to the module to edit the data. can anyone please give some suggestion? Thx…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…