on 10-13-2008 1:13 PM
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
This is by design due to IEEE Floating point limitation
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.