Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Division calculation doesn't work in DVD
Summary
Division calculation doesn't work in DVD
Content
i have a strange problem and looks silly . When Ian's dividing -30/40 should give me -0.75 and I set the decimal places display . it give me 0.0000 . any idea ??
But it when the calculat comes across same number like 40/40 it gives the right result as 1 . Where as all other cases simple 0 is. Even appearing
Answers
-
Just to "FYI", this is the default behaviour in OBIEE / DVD : integer division vs decimal division. The type of the values does matter and it's a common issue in IT when people ignore the types
0 -
other best thing to cast the measures which involved in Division calculation to Decimal. data type setting losing the focus when we refresh the data source.
0 -
I figured this out . You need to change measures data type to decimal , for all the measures which involved in percent calculation .
0
