Line Item:Confirmed PO Delivery Sprint 3

neg177 · September 2020

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

Misbah · September 2020

@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 · March 2021

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.

neg177 · September 2020

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

Line Item:Confirmed PO Delivery Sprint 3

Best Answers

Answers

Categories