PH52140: REPORT USING NUMBER FORMAT WITH SCALE -6 AND DECIMAL PLACES SET TO 1 DISPLAYS DIFFERENT VALUES IN HTML AND EXCEL

APAR status

• Closed as user error.

Error description

• Summarized values are in millions, with scale -6 and one decimal
  place.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• Cognos analytics, by default, uses halfEven rounding rules.
  Microsoft Excel uses different rounding rules which explains the
  difference between HTML/PDF and Excel outputs. There are
  multiple workarounds. First, the customer can change the
  rounding rule to match Excel, if they prefer. See here for how
  to do this:
  https://www.ibm.com/support/pages/how-set-server-rounding-rules-
  data-formatting. Secondly, ensure that any rounding is done
  before data formatting has been applied - for example, at the
  query/data item level. This would ensure that the data that is
  provided to Excel is already rounded. Otherwise you are relying
  on how Excel wants to round numbers.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels