Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Obsolete Stock value (Store) = if ((Daily Cost Price) IS Not Null && ((Csku status)
==”INACTIVE” || (Buying Stop Date) < SYSDATE)),
(Daily Cost Price)* (Closing stock on hand (Store)),
elseif ((Daily Demand Cost) IS Not NULL && ((Csku
status) ==”INACTIVE” || (Buying Stop Date) == True),
, (Daily Demand Cost)* (Closing stock on hand (Store),
else,0)
Can you check if the below works.
= if ([Daily Cost Price] <> Null() and (([Csku status])='INACTIVE' or (Buying Stop Date) < Today()), ([Daily Cost Price])* ([Closing stock on hand (Store)]),
if([Daily Demand Cost] <> NULL() and (([Csku status])='INACTIVE' or ([Buying Stop Date]) ='True'),([Daily Demand Cost])* ([Closing stock on hand (Store)]),0))
Can you check if the below works.
= if ([Daily Cost Price] <> Null() and (([Csku status])='INACTIVE' or (Buying Stop Date) < Today()), ([Daily Cost Price])* ([Closing stock on hand (Store)]),
if([Daily Demand Cost] <> NULL() and (([Csku status])='INACTIVE' or ([Buying Stop Date]) ='True'),([Daily Demand Cost])* ([Closing stock on hand (Store)]),0))
Thanks a lot You're a savior.
Does the NULL function work on a column or does it just works on expressions?