4 Replies Latest reply on Feb 28, 2012 7:42 AM by MarcMcCall

    Average Miles Per Gallon

    MarcMcCall

      Title

      Average Miles Per Gallon

      Post

      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?