Highlighted
Regular Contributor

Level 2 - Sprint 3 INV 01 - POST AND OFFSET

Hi

1)  I am trying to get some sense on POST and OFFSET with the following 2 line items:

    a)  Confirmed PO Delivery          = OFFSET(PO Submitted, Final Shipping Time Weeks, 0)

    b)  Confirmed PO Delivery Test  = POST(PO Submitted, Final Shipping Time Weeks)

    and appreciate explanations on it. 

 

2) If testing above, for Confirmed PO Delivery, if I switch to -Final Shipping Time Weeks, it did not push to Week 6 (2nd diagram).  Why is that so?

 

Star_2-1589980792349.png

 

 

Star_0-1589980980420.png

 

Thanks.

7 REPLIES 7
Highlighted
Occasional Contributor

Re: Level 3 - Sprint 3 INV 01 - POST AND OFFSET

Hi Star,

 

Can you please include a screenshot with your "Final Shipping Time Weeks" line item? It looks like you are comparing it to your "Shipping Time Weeks" line item in your screenshots, which has 1 as the value, but your Final line item might have some other value and this is what you are including in your formula. 

Highlighted
Regular Contributor

Re: Level 2 - Sprint 3 INV 01 - POST AND OFFSET

@smithevan18 

Please refer to the details below:

    a)  Confirmed PO Delivery          = OFFSET(PO Submitted, -Final Shipping Time Weeks, 0)

    b)  Confirmed PO Delivery Test  = POST(PO Submitted, Final Shipping Time Weeks)

With the above formulas, the results are as in Diagram 1.  Am trying to understand why Confirmed PO Delivery is in Week 6 instead of 7 or is it supposed to be in Week 6.  Essentially, am trying to understand the difference between OFFSET and POST.

It will move to Week 7 if the formula is changed to OFFSET(PO Submitted, -Final Shipping Time Weeks - 1, 0) -> Diagram 2 

 

 

Star_0-1589991334399.png

Star_0-1589992297705.png

 

 

 

 

Highlighted
Occasional Contributor

Re: Level 2 - Sprint 3 INV 01 - POST AND OFFSET

Hi @Star,

 

Post and Offset are very similar functions, however, they are going to give you very different results. Offset is going to give you the value from your selected line item x number of periods in the future or in the past. For example, in your line item Confirmed PO Delivery, week 6 is looking back 1 period (Final Shipping Time Weeks = -1) and resulting in your value of 1 since there is a 1 value in Confirmed PO Delivery in week 5. 

 

Post, on the other hand, is going to push the value from your selected line item x number of periods in the future or in the past. For example, in your module, the 1 value in week 5 in your Confirmed PO Delivery line is being pushed 2 periods into the future because that is value in your second argument in your function (Final Shipping Time Weeks = 2). This function also allows you to sum values if they point to the same period. For example, if you also had a 1 in the Confirmed PO Delivery line item for week 6 it would be pushed forward 1 week into your week 7 and combine with your 1 value from week 5 to give you a value of 2 in week 7. Offset will not let you combine values in the same way. 

 

Highlighted
Regular Contributor

Re: Level 2 - Sprint 3 INV 01 - POST AND OFFSET

@smithevan18 

Thank you very much for your detail explanation.  I finally got it 😀 and managed to recreate a sample for the benefit of those who need further understanding.

 

Star_0-1590025682991.png

Star_1-1590025929224.png

 

In Anapedia, the diagram showed 2 boxed in orange.  I would have thought -1 (Jun) should be boxed instead since the example given is 3,000 but I could be wrong.

 

Star_2-1590026255346.png

 

 

 

 

Highlighted
Community Boss

Re: Level 2 - Sprint 3 INV 01 - POST AND OFFSET

@Star 

 

Apart from syntax diff that is OFFSET takes 3 parameters wheres POST takes only 2, the main difference is that POST function lets you add numbers in one cell whereas Offset can't do that.

Highlighted
Regular Contributor

Re: Level 2 - Sprint 3 INV 01 - POST AND OFFSET

Highlighted
Community Boss

Re: Level 2 - Sprint 3 INV 01 - POST AND OFFSET

@Star Exactly. You are bang on target