4 Replies Latest reply: Apr 17, 2018 5:11 AM by Mahitha M RSS

    round() with if logic help

    Mahitha M

      Hi Experts,

       

      Can any one please help me to create below oracle expression in Qlik

      here profitloss  and limitusage are fields.

       

      round(abs(

      case

         when profitloss = 'Y' then least(sum(  [limitusage] )  , 0)

      else

        sum( [limitusage] )

      end)  , 2 )

       

      Thanks in advance.