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

Mvanlaak · February 2022

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 · February 2022

@Mvanlaak Use POST function than LAG

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

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

Best Answer

Categories