HI.
Please could you give me some guidance on the below?IF PO Submitted > 0 THEN POST(PO Submitted, Shipping Time Weeks) ELSE 0
@lcapon
For Confirmed PO Delivery there is No Need of IF ELSE Statement, just use the remaining part of your formula which is POST(PO Submitted, Shipping Time Weeks)
Confirmed Purchase Order Request: I see first part of the formula is wrong which checks IF PO Submitted > 0 instead it should be IF Confirmed PO Delivery > 0 THEN use remaining part of your formula.
Also you will have to follow the instructions carefully, you will be asked to use OFFSET first and then later changed to POST - basically explaining it to you the use cases of POST
Misbah
Does this appear correct?
Don't worry - I've amended to use 'Final' Shipping weeks and now appears correct.
I am stuck at Activity 2.3.8.2 Import into DEM01 Module I don't know how to map Time. Could anyone please help with this: I thought it should be "Patterns with Separators" Y-M but it failed "Expected month name or number in date/period" I tried all "Match Names" (could not choose Language), "Periods" with "Custom…
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…