Math operations in result column of a UNION (combined analysis)

Question

I need to know a % of UNION result, for that I added a column result to UNION operation. If i only select that it show me one column and it Works perfectly but when i try to make math operations the result is incorrect.
Can i make math operations in result column of a UNION?

Thomas Dodds · Answer

Passing the UNION from the presentation server to the BI server is about the most inefficient and least functional way to do things.  Try changing the logical and/or/ physical data models to achieve the requirements -- the use of information drives the model (both logical and physical) design.

BUT here's how one person was able to do some simple calcs with UNION in Answers:  OBIEE in IL: OBIEE - Calculation between results of a union

Jagadekara · Answer

Hi,

Re: 2. How do I ask a question on the forums?