Finding an Ave score based on a time frame
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.