I have a report where I have two numbers in each cell of a cross tab, and I need to get a third by dividing one of the numbers by the other. I am displaying room revenue and occupied rooms, and I need to calculate the third field to get Average Daily Rate.
I did try creating an actual ADR field in the report wherein I divide
sum({fdroomstat.room_revenue})/sum({@Rooms Occupied})
But then when I add it to Summarized Fields I am forced to use an aggregation so I use AVG... I thought that worked fine for each individual cell but I have just realized that's not even the case.
In any case, when you get to row and column totals, instead of adding all the revenue and dividing by all the rooms occupied, you get a random number that is meaningless.
What am I missing? I am certain this is simple but I just cannot see how to do it.
Any help would be much appreciated! Thank you.
Add comment