Print Page - Filtering out Zero Amounts

Title: Filtering out Zero Amounts
Post by: jmills on 10 Jul 2012 01:41:45 PM

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?

Title: Re: Filtering out Zero Amounts
Post by: pricter on 10 Jul 2012 03:39:18 PM

Have you set the Aggregate property for this data items?

Title: Re: Filtering out Zero Amounts
Post by: jmills on 10 Jul 2012 04:41:04 PM

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

Title: Re: Filtering out Zero Amounts
Post by: pricter on 10 Jul 2012 05:02:40 PM

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

Title: Re: Filtering out Zero Amounts
Post by: jmills on 13 Jul 2012 12:47:15 PM

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

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

Title: Re: Filtering out Zero Amounts
Post by: wyconian on 16 Jul 2012 09:04:50 AM

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

Title: Re: Filtering out Zero Amounts
Post by: jmills on 02 Aug 2012 11:07:31 AM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jmills on 10 Jul 2012 01:41:45 PM