Displaying Row count of Straight table as an header Text

[#1]

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

[its_anandrjs]

Hi,

Use isnull( ) fuction to eliminate null values in count.

Rgds

Anand

[#3]

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