Problem with a simple calculation

Question

Hello everyone,

I am using OBIEE 12c , well in my table i have 2 indicators

- Number of DAP

- and Number of DAP with a filter  ( value of a dimension )

I created a calculated item  where i want    NUMBER OF DAP ( with a filter )  / NUMBER OF DAP

But the results i get are not correct

Thank you if you can help me

John305 · Answer

Thank you Gianni !

Gianni Ceresa · Answer

Hi,

The result is right, the calculation is doing exactly what you asked: INTEGER / INTEGER = INTEGER

Just few hours ago the same topic covered: Remove default floor function while dividing a column by another in OBIEE

You need to cast one of the 2 as double, so you have a INTEGER / DOUBLE = DOUBLE