Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Union request summing problems
I am creating a report with following columns:
Market Code,Room Nights, Room Revenue, ADR, . ADR is calculated by Room Revenue/Room Nights.
COR 5 450 90
IND 3 360 120
Total 8 810 101,25
The above is correct.
If I know I used the Combine Results based on uniion as i want to add another layer showing the same figures by Channel, the total for room nights and Room Revenue will be still correct , but ADR will show the value of the first row in each layer. In market code layer in the ADR Total i would have 90.
Any idea?
Regards
Sorry, it doesn't save the format. Here you are
Answers
-
Isn't this the same exact thing as https://community.oracle.com/tech/apps-infra/discussion/4476885/wrong-adr-in-a-total#latest ?
Double posting is against the rules you accepted when joining the community. You have an open thread, post the addition details there if needed instead of opening another one.
0 -
Yes sorry, you are right.
Regards
0 -
I will remove the other one and leave this one. Thanks
0 -
Hi Gianni, sorry, but it seems i can not remove the other one.
0
