Line Item:Confirmed PO Delivery Sprint 3

Hi,

Would like to know if this is the correct formula for the Line Item:Confirmed PO Delivery in Module INV01. If not please give me some guidance.

OFFSET('PO(Purchase Order) Submitted', Shipping Time Weeks, 0)

or should I use POST(PO Submitted, Shipping Time Weeks)

Thank you

Accepted answers

Misbah

@neg177

If you follow the steps, it will ask you to use OFFSET but later you will be asked to change it to POST so that you yourself can see what are the use cases where POST can be used.

POST can pull and aggregate multiple values into one cell whereas OFFSET can't do this.

Misbah

varunsavai

Yes.

Follow the link:

https://help.anaplan.com/en/082cb491-879c-4711-b5c6-9ed162391bb1#:~:text=For%20a%20variable%20offset%2C%20LAG,to%20give%20the%20target%20value.

All comments

Misbah

@neg177

If you follow the steps, it will ask you to use OFFSET but later you will be asked to change it to POST so that you yourself can see what are the use cases where POST can be used.

POST can pull and aggregate multiple values into one cell whereas OFFSET can't do this.

Misbah

neg177

So OFFSET can only do so with a singular value verses POST that can pull in multiple values....correct?

varunsavai

Yes.

Follow the link:

https://help.anaplan.com/en/082cb491-879c-4711-b5c6-9ed162391bb1#:~:text=For%20a%20variable%20offset%2C%20LAG,to%20give%20the%20target%20value.

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…