If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to count the -ve values .

Started by laxmanrao83, 20 Aug 2009 07:15:17 AM

Previous topic - Next topic

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)