I am trying to calculate the average daily rate for a scorecard in Looker.
It is a very simple formula… just not working!!! Ugh
The formula is to calculate Room Revenue / Occupied Rooms and display this information for every day. I have both of these data points as fields already. When I write the formula, the average is not correct. I think it has something to do with aggregation.
Here is a sample of the math on one day of many.
$22,956.46 / 131
This should return the value of $175.24
However, its returning this… $168.23
Any ideas of how to fix this??