AnsweredAssumed Answered

Finding an Ave score based on a time frame

Question asked by snkm on Mar 1, 2010
Latest reply on Mar 2, 2010 by comment_1

Title

Finding an Ave score based on a time frame

Post

Issue:  I'm auditing employees and I need the average of their scores based on the year 2009.  Here is my current calculation:

 

If (Project Date In  ≥  Date ( 1 ; 1 ; 2009 ) and Project Date In   ≤   Date ( 12 ; 31 ; 2009 ); Average ( Audit_Total ); "n/a")

 

This calculation however does not seem to be working.  Please help.

Outcomes