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
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...
Thanks!!! This article help me!!!!
ReplyDelete