Calculate percentage results

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a field to show the running average during a 12 month period. My calculation is:

Average([Average Jan Results], [Average Feb Results],[Average Mar Results],[Average Apr Results], [Average May Results],[Average Jun Results],[Average Jul Results], [Average Aug Results],[Average Sep Results],[Average Oct Results], [Average Nov Results],[Average Dec Results]).

Jan results is 94%. The rest of the year is default at 0%. The field should display 94% but instead it is showing 7.89%. What am I missing?

Photo of Jerry

Jerry

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb
Try setting the fields all to not treat blanks as zero - I assume that these are Summary fields?  Let me now if that fixes the problem.
Photo of Gaurav

Gaurav

  • 50 Points
You are calculating the average of the 12 months period, It will always be sum of 12 months period result/12
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb
Not necessarily correct.  The Average function ignores null values.