If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Sum of columns not showing when both are zero

Started by jeremywv, 09 Apr 2025 12:52:30 PM

Previous topic - Next topic

jeremywv

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?