Line Item:Confirmed PO Delivery Sprint 3

neg177
Regular 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 ACCEPTED SOLUTIONS

Accepted Solutions
Misbah
Moderator

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

View solution in original post

varunsavai
New Contributor

Re: Line Item:Confirmed PO Delivery Sprint 3

3 REPLIES 3
Misbah
Moderator

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

View solution in original post

neg177
Regular 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?  

varunsavai
New Contributor

Re: Line Item:Confirmed PO Delivery Sprint 3