Calculating Average Daily Rate Not Working

[CGlennon]

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?? 

[Dawid]

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.