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

@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.

neg177

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