1 Reply Latest reply: Jul 14, 2016 3:18 AM by Gysbert Wassenaar RSS

    Edditing formula

    June Kim

      Having hard time figuring out this formula below works on Qlik Sense.

       

      Is there anyone who knows how to make it works?

       

       

       

      if(isnull([ship_dt]) = false and isnull([p_return_dt])=false) then

      [수주금액]*(-1)

      else if (isnull([ship_dt])=false and isnull([p_return_dt])=true) then

      [수주금액]

      else

      0

      end