3 Replies Latest reply: Jul 14, 2016 7:09 AM by Sunny Talwar RSS

    if(isnull) statement

    June Kim

      Try to use this formula but i'm getting 'Error in Expression: If takes 2-3 parameters'

       

      Help me with this to work properly.

       

       

       

      if(isnull([SHIP_DT]) = false and isnull([P_RETURN_DT])=false) then

      (sum(([SALE_RPRICE])*([ORDER_QTY]))*(-1));

      else if(isnull([SHIP_DT])=false and isnull([P_RETURN_DT])=true) then

      sum(([SALE_RPRICE])*([ORDER_QTY]));

      else

      '0';

      end if

       

       

       

      Thank you