1

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?

enter image description here

ORLANDO VAZQUEZ
  • 79
  • 8

1 Answers1

1

Detail filter, property after aggregation

Total ([Tran Amount] for [Loan#]) <> 0
VAI Jason
  • 534
  • 4
  • 14
  • 1
    @ VAI Jason: That works except when there are additional trans that don't wash. If I incorporate the Due date it then seems to work great: Total ([Tran_Amt] for [Loan#],[Due_Date]) <>0 Thanks! – ORLANDO VAZQUEZ 44 mins ago Delete – ORLANDO VAZQUEZ Dec 10 '19 at 17:34