Could someone please tell me what I am doing wrong with these formulas. @Misbah 1. Beginning Inventory = IF 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN 'DAT01 Beginning Inventory'.Beginning Inventory ELSE PREVIOUS(Ending Inventory) 2. Submit Purchase Order Request= OFFSET(PO Submitted, Shipping Time Weeks, 1) = 1 3. PO Submitted = IF Submit Purchase Order Request THEN 1 ELSE 0 4. Confirmed PO Delivery= IF PO Submitted > 0 THEN OFFSET(PO Submitted, Final Shipping Time Weeks, -1) ELSE 0 5. Confirmed Purchase Order Receipt= IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0 6.Shipping Time Weeks= 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product]
... View more