Line Item:Confirmed PO Delivery Sprint 3

[neg177]

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 · Accepted solution]

@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 · Accepted solution]

Yes.

Follow the link:

https://help.anaplan.com/en/082cb491-879c-4711-b5c6-9ed162391bb1#:~:text=For%20a%20variable%20offset....