Liveware Publishing Support Forum

Is there a way to count records, but only if the value is not 0.____For example. sorting by Date, I have values from a record.____10/01/04 has three records with values of 0, 25, and 56. I would want this days count to be 2__10/02/04 has 4 records with values of 0, 24, 0, 0. I would want this days count to be 1. __ __ __I know someone knows how to do this, so I thank you in advance.__Rick Johnson____Ver10.1

Use a condition in your total field where it has to be greater than zero (e.g. FIELD > 0).

Thank You. I have done thousands of totals in my day, but never once had I seen that condition field in the total creation dialogue. It works perfecto........__Rick Johnson