Level 2 Sprint 3 Confirm PO

roblund

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.

Accepted answers

All comments

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

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

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

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

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

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…