Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight Table which gets filtered as per a check box selection. Hence the rows of the straight table changes dynamically. I have also suppressed the rows with null values and therefore the null rows does not getting displayed.
I need to display the total row count of the straight table as a header (say in a text box object). I am using count(Field1 & Field2). The count is getting displayed but it also includes the null rows that have been suppressed. Is there a way to eliminate null rows from the count?
Thanks in advance
Hi,
Use isnull( ) fuction to eliminate null values in count.
Rgds
Anand
Thanks Anand !!!
I have used isNull function and it does not eliminated the null rows.
Count( distinct Field1&Field2 & Field3 & if(isNull(Field4),0,Field4))
Can you please send me how to use the isNull function in a count?
Regards
Arvind