Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Divide 2 Columns in Union Report
Answers
-
Issue resolved by using SUM BY in result column. Thanks everyone.
0 -
And THAT is why you normally do things in the model and not with UNIONs. Unions should be the very last option you ever choose. OBI tries to aggregate according to models and when you override this - by unions for example - then this becomes dodgy and you need to write the SUM or AGGREGATE yourself.
0 -
Completely Agree Christian. This analysis pulls data with different filter on each union query and therefore it was not possible to fit in a single model.
0 -
Ebin Cherian wrote:This analysis pulls data with different filter on each union query
Bummer
0
