Default rounding when a numeric column is divided.
When I perform an arithmetic division over any numeric column from the subject area, I do not get any fractional value in my BI Answers report. i.e. when a value 50 is divided by 3 I get only 16.00 and not 16.67 even when the column data is rounded to 2 decimal places. But the same works when multiplied with a fractioned number i.e. when 50 is multiplied by 1.33 then I get 66.50 as the result.
Does any kind of default rounding happening with the result when a division is being performed in BI Answers? Is there any ways to overcome this issue? I use OBIEE 10.1.3.4.1
Regards,
Vishnu
Edited by: Vishnu Ramakrishnan on Jun 15, 2012 2:16 AM
Edited by: Vishnu Ramakrishnan on Jun 15, 2012 2:19 AM
Edited by: Vishnu Ramakrishnan on Jun 15, 2012 2:21 AM