Omit Zeros When Summing a Column In Reports

[Learn2010]

I have a report based on a table. In the report I sum the columns. In a textbox ControlSource I use "=Sum([ColumnTotal])" and it works. Some of these numbers are zeros. I would like to exclude the zeros in the total. How do I do that?

Thank you.

 

[pbaldy]

I'm confused, as zero values wouldn't affect the sum anyway.

 

[Learn2010]

What I meant was I need to count the items in the column that are greater than zero.

 

[pbaldy]

=Sum(IIf(FieldName > 0, 1, 0))

The field name instead of 1 if you want to sum rather than count.

 

[Learn2010]

You helped me figure it out. I used

=Count(IIf([FieldName]>0,1))

and got the correct count.

Thanks.

 

[pbaldy]

No problem. What I posted should have returned the same result.