Synopsis/Observed Behavior:
-Migrated full client reports from v5.1.9 to XI R2.
-On BO level without using Round function, the value is rounded off to 2 decimal places but itu2019s appending the Minus sign in front of the value for example:0.000000000001254 It is rounded of to -0.00 instead of 0.00
- When I applied the round of function in the following manner then we donu2019t get the Minus sign appended in front of 0.00.
=Round (<Object Name>, 2) or ==ToNumber (FormatNumber (<Object Name>,u201D0.00u201D))
-Issue is replicable in full client and through info view for deski reports.
-I made a webi report and test the issue in all the environments but issue is not replicable
-I Tested the issue in following environments
Environments in which the issue was tested.
1. BOXIR2 SP2
2. BOXIR2 SP3.
3. BOXIR2 SP4.
4. BOXIR2 SP4 FP4.3.
5. BOXIR3.1.
-Seems to be related to IEEE floating point limitation.
Could anyone please help me as 90% of my customer's reports are affected.
Regards,
Sarbhjeet Kaur