3 Replies Latest reply on Mar 2, 2010 5:53 PM by comment_1

    Finding an Ave score based on a time frame

    snkm

      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.