Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

divide two row values using same column of OTBI analysis

Received Response
61
Views
7
Comments
mknmdp
mknmdp Rank 3 - Community Apprentice
edited Aug 28, 2025 12:48PM in Oracle Transactional Business Intelligence

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

Answers

  • mknmdp
    mknmdp Rank 3 - Community Apprentice

    Anyone on this issue?? need urgent inputs

  • Wayne Van Sluys
    Wayne Van Sluys Mod

    you cannot calculate across rows.

  • mknmdp
    mknmdp Rank 3 - Community Apprentice
    edited Aug 6, 2025 7:34PM

    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
    mknmdp Rank 3 - Community Apprentice

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

    image.png
  • Wayne Van Sluys
    Wayne Van Sluys Mod

    You cannot calculate across rows.

    why can you not do as columns?

    How is logic different for CEO and Emp Co ?

  • mknmdp
    mknmdp Rank 3 - Community Apprentice

    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
    Jerry Casey Rank 6 - Analytics Lead
    edited Aug 20, 2025 12:25PM

    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.