Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Wrong ADR in a Total

Question
1
Views
0
Comments
fabryddorf-Oracle
fabryddorf-Oracle Rank 4 - Community Specialist
edited Aug 13, 2024 7:10PM in Oracle Analytics Cloud and Server

I am creating a report with this figures. Room Nights, Room Revenue, ADR=Room Revenue/Room Nights by Market Segment, Channel, Room Type etc..

To achieve this i am joining the same subject area multiple time for the number of segment (market, channel, room type etc..)

When I create a Total by Segment, the Room Nights and Room Revenue Total are correct , but the ADR is taking the first value in the row, which is wrong. It should actually do the total divided by the number of rows. I know it is question of how to aggregate that column, but i do not see the right aggregation option.

Any idea?

Regards