Level 2 Sprint 3 Activity (Final) Shipping Time Weeks



This thing is driving me nuts. My formula for "Confirmed PO Delivery" works when referring to the Shipping Time Weeks but won't work when referring to the Final Shipping Time Weeks. Both line items are formatted the same way. ggggrrrrr


I would very much appreciate if somebody can tell me what is wrong.



Best Answer

  • bhatjaved

    @Mvanlaak Use POST function than LAG

    You need to write IF Confirmed PO Delivery <>0 then POST(----) ELSE 0 .