AnsweredAssumed Answered

Calculate average of multiple fields - new user

Question asked by JSha on Apr 21, 2009
Latest reply on Apr 29, 2009 by JSha

Title

Calculate average of multiple fields - new user

Post

I am a new user and I am trying to recreate a function I had in Excel.  I have people who have monthly totals (I input) then I need the 6 month average.  Example Joe - 12/08, 1/09, 2/09, 3/09, 4/09, 5/09, 6 month average.  Each person also appears in 2 other tables so I don't want to create a seperate table for each person.  I only keep 6 months worth of monthly totals so it drops the oldest off every month.  Is there any way to do this?

 

I need the 6 month average to appear as a field in another table.  I wouldn't mind adding a field and deleting another every month but then I would have to move all the numbers or rewrite a script (I think).

 

Thanks!

Outcomes