Problem with a simple calculation

John305 · Dec 28, 2017 6:30AM

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

Gianni Ceresa · Dec 28, 2017 7:04AM

Hi,

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

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

John305 · Dec 28, 2017 10:02AM

Thank you Gianni !

MFA for Oracle Community