round() with if logic help

[mahitham]

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.

[sunny_talwar]

May be like this

Round(Fabs(If(Profitloss = 'Y', RangeMin(Sum(limitusage), 0), Sum(limitusage))))

[mahitham]

Hi Sunny,

Thanks for your reply its rounding by 2 digits where to apply 2 in your expression also in the query mentioned abs not fabs.

round(abs(

case

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

else

  sum( [limitusage] )

end)  , 2 )

[sunny_talwar · Accepted solution]

May be this

Round(Fabs(If(Profitloss = 'Y', RangeMin(Sum(limitusage), 0), Sum(limitusage))), 0.01)

[mahitham]

Thanks sunny its working...