AnsweredAssumed Answered

calculating average for this month

Question asked by bobinaustin on Nov 15, 2015
Latest reply on Nov 16, 2015 by skywillmott

I think there is a complex formula that might be needed for this but...  i am trying calculate an average number for a single field based on three time frames.  This week (weeks tarting saturday), this month (regardless of what day it is in the month), and this year (calendar year regardless of where we are in the year).  I am sure current date and get will figure into this somehow but if you have a formula that will do please let me know.  For my db the field name is "Reading" and it is a numeric value only.

 

THANKS!

Outcomes