Calculation field summary incorrect
OK, here is another bonehead question:
I have a calculation field that counts weekdays between two dates, when I try to add an average summary field based on this calc field, I get a negative weird number. Here is the calc for the days:
7 * Int ( ( Medical Exam Received - Medical Exam Requested ) / 7 ) +Middle ( "0012345501234544012343340123223491111234010012340" ; 7 * (DayOfWeek ( Medical Exam Requested ) - 1 ) + DayOfWeek ( Medical Exam Received ) ; 1 )
Any help here would of course be appreciated beyond belief.