level2 3.3.5.2 Confirmed PO Delivery formulas

RAJAT786

POST(PO Submitted, Shipping Time Weeks) worked in Confirmed PO Delivery Formula.OFFSET(PO Submitted, Shipping Time Weeks, 0) is right according to the hint in the module but it is giving wrong results  as adding value in the current and 2 weeks ago column not filling the value in after two weeks.added a screenshot. Plz explain the reason

3_144351.jpeg

JaredDolich

@RAJAT786 

Good question. First, POST is the right function for Confirmed PO Delivery. The difference between POST and OFFSET is that POST calculates a value and moves it to the time period you wish. Can be dynamic or static. OFFSET takes every value of a different line item and places it in the line item your calculating. Subtle difference but in our case we are calculating whether or not a planner has indicated the need for a PO. We need to move that value to the right week for evaluation.