Line Item:Confirmed PO Delivery Sprint 3

Highlighted
Frequent Contributor

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 

 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Line Item:Confirmed PO Delivery Sprint 3

@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

Highlighted
Frequent Contributor

Re: Line Item:Confirmed PO Delivery Sprint 3

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