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

 

Count() returning blank or unknown value-not able to use in calculations/disp

Started by raja1718, 13 Dec 2009 11:18:03 PM

Previous topic - Next topic

raja1718

Guys......I have some thing like score card.its has several boxes contains the count for diff queries.Finally i am calculating (adding) sum of all the counts of different boxes.But when one query results comes "Zero" its not displaying any thing its showing the blank.When the total of all the counts will also becoming zero.

when i used the missing value zero its displays zero in the individual box but not in the total count.its making all the values becoming zero.

I have tried all the combination's in the data item expressions like is null ,is missing and blank check never worked out.

I am not sure why if no records in the query....count() have to return zero or null or blank or some thing.but i cant find which value its returning.


Please any one help me to resolve this issue

Thanks in Advance

Raja[/b]