I am trying to do an a calculation and having some trouble. The formula in my Average Daily Usage column is (Oil Usage / Run TIme Hours) * 24
I guess the formula is technically working when look at columns, but I want this formula to calculate for the subtotal columns when i select a range of dates. So the column in blue for Average Daily Usage should be 1.714 not 2.34. How do I accomplish this? Guess i might need to make some adjustments in ETL