Calculating Average Daily Rate Not Working

  • 18 January 2023
  • 1 reply

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

1 reply

Userlevel 7
Badge +1

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.