How to avoid blank values while calculating Count on calmonth

[Former Member]

Hi Gurus,

I am facing an issue in my current report i want to calculate count for calmonth but i need to avoid blank values i.e need to display count for the months  for the values avaliable.

see the below example:

                         jan2013      Feb2013     Mar2013     Apr2013    May2013     June2013

Savings             1000                             3000

As per above example if we apply count(calmonth) by default it returns 6.

But my requirement is if we applied count it should return only 2 because savings have only two values for two months

I tried this formula =Count([Calmonth]) where([savings>0) but it returns 6 only.

Please throw some light on the issue

Any help would be appreciatable.

Thanks In advance.

Regards,

Mahesh.

[Former Member]

hi,

when checkin for null values, keep in mind that , at report side , null is greater than anything.

Try this instead : =Count([Calmonth] where(Not(IsNull([savings]))))

CHeers,

ROgerio