2 Replies Latest reply on Aug 30, 2012 9:43 AM by margaritafernandez

    Average of a Difference

      I want to calculate the average of the 4-year difference, it works well if I have all the school with a listed change, however when there is no change the average is too high.  I'm not sure if it is using the blank as a 0 or not.  How do make it ignore the blank values for the average?