Level 2 Sprint 3 Activity 3.3.5.5 (Final) Shipping Time Weeks

Mvanlaak

Hi,

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.

 

Michelle

bhatjaved

@Mvanlaak Use POST function than LAG

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