Question & Answer
Question
Different Planning Analytics clients seem to exhibit different rounding behavior when they display the same value.
For example, when the display format is set to show the value 2097152.125 to two decimal places:
- A Planning Analytics Workspace exploration, and a Planning Analytics for Excel custom report, both round the displayed value up to: 2,097,152.13.
- A Planning Analytics Workspace websheet, and a TM1 Web websheet, both round the displayed value down to: 2,097,152.12.
However, all four clients display the value 2097151.125 by rounding up to: 2,097,151.13.
Cause
This difference is a side effect of IEEE-754 floating point arithmetic in Java.
While the value 2097152.125 can be displayed correctly, and does not have any problems with IEEE-754 approximation, the intermediate calculations used to evaluate the formatting run into these issues, leading to the reported behavior.
Answer
This behavior is correct for TM1 Web, which is a Java based web application. Its floating point arithmetic differs from Excel, which is C# based.
This is purely the display behavior of the Java based web application; the underlying data value is unaffected.
The Java based websheets are operating as expected and as designed.
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m50000000KzL0AAK","label":"Planning Analytics-\u003EPlanning Analytics Workspace-\u003EModel Data and Reports"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Product Synonym
PA;TM1;PAoC;PAL;PAW;PAfE;PAx
Was this topic helpful?
Document Information
Modified date:
23 February 2023
UID
ibm16957052