3 Replies Latest reply: Apr 25, 2016 6:53 AM by Shivam Sarin RSS

    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.

    Shivam Sarin

      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)