Count Non-Zeros Formula

[sopomeres]

How can I count occurences of a field in the detail section, but omitting zero values? So, If I have detail listing:

96
93
0
99

Then a Count formula would provide me with a count of 3.

Thank you in advance!

 

[goranm]

Hello !

Just create a formula like:

if {YourField} <> 0 then
1
else
0

Place it in the detail section and insert a summary (count) on the formula.

/Goran

 

[mbarron]

You'll want to do a Sum summary, if you do a count, it will also count the zero's Mike
If you're not part of the solution, you're part of the precipitate.

 

[sopomeres]

I used the sum summary and it did work properly.

Thank you both!

Much appreciated!

 

[goranm]

Of course Mike !

I don´t know what I was thinking about.

/Goran