cancel
Showing results for 
Search instead for 
Did you mean: 

Minus Sign is appened infront of the value.

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

This is by design due to IEEE Floating point limitation