Count number of items on a report

[amayer]

I have a need to count the total of displayed items on a report. I have a total of seven fields which may contain data. They can be null, so the expression needs to be able to handle the null value. I am able to get a total of 0 which I think is because of the null values, but have been unable to incorporate any null value handling wtih the nz function.

 

[amayer]

I found that I was putting the parens in the wrong place. It works as =(count([item1])+count([item2])).

Tony.