AnsweredAssumed Answered

Average Miles Per Gallon

Question asked by MarcMcCall on Feb 27, 2012
Latest reply on Feb 28, 2012 by MarcMcCall


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?