Average Miles Per Gallon
I have 7 calculation fields for miles per gallon on one table. Day 1 through 7. I'm trying to figure out how to add those together and get an overall 7 day average. I set it up like this Sum(MilesPerGallonDay1;MilesPerGallonDay2;MilesPerGallonDay3;MilesPerGallonDay4;MilesPerGallonDay5;MilesPerGallonDay6;MilesPerGallonDay7)/7 However, I would like to do it so it only calculates when there is a value in the other fields. So if I have sat, sun, tue, it wont need to be /7 only /3 would I use a Case formula for this?