Filter query results where original fee and reversals wash to zero
In Cognos 10 query, What method is best to remove items from list below where the Fee charged and the fee assessed Tran Amounts are a wash, ie, sum to zero?
Solution
Detail filter, property after aggregation
Total ([Tran Amount] for [Loan#]) <> 0
- Cognos crosstab columns not resizing
- Cognos 10 Group Subtotal not showing
- IBM Cognos IF/casewhen + _days_between
- TM1 : Error :Incorrect syntax Near '|' (inserting numeric value into sql query)
- Adding parameters to SQL select and using them in Cognos Report Studio Version 10.2.1
- Cognos equivalent of excel's sumif() function
- Cognos report (gererate query in Query explorer)
- Cognos Static prompt values to be passed to SQL
- COGNOS: Compare column with previous column in a crosstab with dnamically generate columns
- Filter query results where original fee and reversals wash to zero
- COGNOS: Calculation in a cross table based on condition from other dimension
- How can I make a column display certain text based on another columns data in an IBM Cognos report?
- Create a SQL query based Daily report with Incremental Records
- Filter for Report with options for relative Dates throws errors
- Convert Varchar to ANY time format
- Cognos 10.2.1 - Missing chart axis maximum setting
- Exporting individual Congos Reports via command line
- cognos 10.2.2 -Report Studio
- Cognos Report Studio (case statement) - Syntax error
- Cognos CAST within a CASE
- Cognos Report totaling hours over time
- Send Cognos Burst Reporting to multiple emails
- IBM Cognos Analytics with D3.js Bar Chart height problem
- Cognos Report with Multiple value prompts
- Need help building a Data Item in Cognos Report Studio
- How to format crosstab corner in Cognos
- Dynamic Query Item Used for Sorting
- Is it possible to pass parameter in the cognos by SQL?
- How to change Chore properties in cognos-tm1 process?
- How to avoid saving report output version in cognos?