How to count the -ve values .

[laxmanrao83]

Hi All,

How to count the -ve values .
ex:
i have gross profit column.in that i have -ve values.
i want to count that -ve values

Thanks in Advance
Laxman

[uttam.mistry]

count(if gross profit < 0.00 then 1 else null)
or
sum(if gross profit < 0.00 then 1 else 0)

[rama83]

Hi,

Try this way

if(gross-profit<0)  then (count(gross_profit)) else (null)