Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Problem with a simple calculation

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
Answers
-
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
0 -
Thank you Gianni !
0