AnsweredAssumed Answered

Calculation field summary incorrect

Question asked by illbe on Jan 13, 2011
Latest reply on Jan 13, 2011 by philmodjunk

Title

Calculation field summary incorrect

Post

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.

Tom

Outcomes