divide two row values using same column of OTBI analysis

mknmdp

Hi,

Each of the two rows is derived from analysis of same subject area. The reason for this design is i cannot accommodate two different conditions in same analysis so I had to develop two reports each with different conditions.

I'm getting two rows now so i'm looking to divide row1 by row2 of one column to get the value in 3rd row. How can i accomplished this task?

thanks

mknmdp

Anyone on this issue?? need urgent inputs

Wayne Van Sluys

you cannot calculate across rows.

mknmdp

how can i design as two rows i'm getting using UNION SET operation ?

i want to display divide value in third row. thanks

mknmdp

Hi any updates? I want to calculate division as CEO/Emp Co and display value in the ratio row.

Wayne Van Sluys

You cannot calculate across rows.

why can you not do as columns?

How is logic different for CEO and Emp Co ?

mknmdp

both are coming from same subject area.. basically saying if ceo then salary else sum of salary all employees ..

thats how two rows shows in result..

i need to divide to get the ratio for ceo sal/emp sal

thanks

Jerry Casey

Use a filter formula in each column of a single row. e.g.: FILTER ("Salary" USING "Title" IN ('CEO')). Do the same for Employee. Use a third column to divide one column by the other.