Can anyone please help me with the if else ladder. Whenever I'm trying to convert the below statements into sense I'm getting a error :"Error in expression ')' expected. I'm creating this as a new measure.

[#1]

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)

[arasantorule · Accepted solution]

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))

[#3]

Thanks a lot You're a savior.

[#4]

Does the NULL function work on a column or does it just works on expressions?