COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: jeremywv on 09 Apr 2025 12:52:30 PM

Title: Sum of columns not showing when both are zero
Post by: jeremywv on 09 Apr 2025 12:52:30 PM
I have (2) calculated fields in a data source that is the sum of multiple columns in dollars.    When I place these 2 columns in a report, it will show the row if there is a value greater than zero in either column.  If both columns are zero, it omits the row completely.  I've tried all different ways including a calculated field and a query calculation.  Any idea on how to fix this?