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??
We can’t really know how to fix it because we can’t see your code, your calculations, or what you do to get all those values.