Filtering out Zero Amounts

[jmills]

Hi All,

I am working on a list report which comprises of Earnings, Deductions and Taxes.  When I add the following filter, I get the following results:

Detail Filter: Earnings <> 0 OR Deductions <> 0 OR Taxes <> 0

Results:
Earnings  Deductions  Taxes
1234.00  0.00            0.00
0.00        1234.00      0.00
0.00       0.00            1234.00 

Is there a way to get these results on one row instead of 3?

[pricter]

Have you set the Aggregate property for this data items?

[jmills]

All 3 fields are set to Total Aggregate Function, and Automatic Rollup Aggregate Function

[pricter]

Try to set the Rollup Aggregate to Total also and auto summarize and grouping is set to yes

[jmills]

found out that my detail filter: Earnings <> 0 OR Deductions <> 0 OR Taxes <> 0

should be Earnings <> 0 AND Deductions <> 0 AND Taxes <> 0

[wyconian]

did your filter work?  It looks like it should have returned no data because none of the rows mathc the filter criteria of all rows not being zero

[jmills]

I wasn't expecting it to work, thus it was causing me so much trouble.  after playing with it a few times, the solution above worked.