Null values in a report total - Cognos upgrade

[PJL81]

Hi,

I have a report in report studio which uses set and then uses total(current measure within set to sum the et for subtotals etc. However recently we upgraded from Cognos 10.1 and some off the formulas no longer work. It seems to be something around NULL values where a whole row is null in teh report for example an account or cost centre then the totals following that area of the repoort are also null. Prior to the upgrade it was not treating zero blalnces as null and was adding through. Has anyone else experienced this?

[srmoure]

I am experiencing the same issue. Did you find a solution ?

[srmoure]

The upgrade did a reset to default of the settings. I found a solution to the issue:

Treat Nulls as Zeros within Calculations
By default, the Dynamic Query Mode propagates nulls in calculations. However, it is possible to override the default behaviour for DMR packages through configuration settings similar to those for pure OLAP data sources.
Impacts: Calculations on data items that contain null data values.
Usage: This set of parameters controls whether or not null data values are treated as zeros when used in calculations. If the parameters are enabled, 100 + null would result in 100. If the parameters are disabled, 100 + null would result in null. By default, these parameters are disabled.
Interoperability with other parameters: None
Setting these parameters: The parameters are available within the file c10\configuration\xqe\dmr.properties as shown here (with the default settings):
null.plus.operator=null
null.minus.operator=null
null.multiply.operator=null
null.divide.numerator=null
null.divide.denominator=null
null.modulo.dividend=null
null.modulo.divisor=null
Show less
To enable this feature, change the null values to zero as follows:
null.plus.operator=zero
null.minus.operator=zero
null.multiply.operator=zero
null.divide.numerator=zero
null.divide.denominator=zero
null.modulo.dividend=zero
null.modulo.divisor=zero
Show less
These changes will be picked up once the IBM Cognos 10 service is restarted. After the restart, this change will affect all queries against any DMR data source through IBM Cognos 10. In a distributed environment, this change will need to be made on all IBM Cognos 10 servers performing data access.