Friday 28 June 2013

Division of numbers/ intergers- Results in unexpected Data

In OBIEE 11g, We noticed that while dividing two integer numbers, the data result was not as expected. With data format as percentage.

For example- 607/ 1257 resulted in 11%

My colleague, changed the formula to double and the results were matching.

For example- cast(607 as double)/cast(1257 as double)*100.00

Comments are always welcome...