nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Divide 2 Columns in Union Report

Ebin Cherian

Hi All,

Oracle Business Intelligence 12.2.1.1.0.

I am struggling to create a calculated column which perform division on Union.

I need to create a calculated column to perform calculation Amt 1/ Amt 2.

So far result is correct. Now I am going to add a Region column to both analysis and then exclude it in the pivot table layout. When I do that, Division result is not correct.

How can I fix this issue ?

Thanks

Ebin

Find more posts tagged with

Accepted answers

All comments

Ebin Cherian

Issue resolved by using SUM BY in result column. Thanks everyone.

[Deleted User]

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.

Ebin Cherian

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.

[Deleted User]

Ebin Cherian wrote:This analysis pulls data with different filter on each union query

Bummer