I have a performance evaluation where I am trying to calculate the total number of "exceeds ratings". I am using the following script and it works for a single field. I am now trying to calculate the total number of exceeds for multiple fields. this.rawValue is my calculating field. FieldName is the field the rating is entered. if the number entered is < 36 there should be no +1. So in other words, if I have 4 ratings entered that are > 36 my calculating field should say 4. This may be simple for most but I do not do this to often. Please help. Thank you!
Since each row has different information, I'll presume they are also named differently. Something like taxCollectorCustomerSatisfaction.tfMid and telephoneSurvey.tfMid for the first two rows. Whatever you called them, just make sure you're using the row name and cell name in your script.
if (taxCollectorCustomerSatifaction.tfMid > 36) then t=t+1 endif
This is my table...see the third line up from the bottom...there are three small boxes, each box should represents Exceeding, or Achieving or Below. Each box should add the Mid Year Results from above. So in other words, if there are 5 scores entered above that are > 97, then the number 5 should be entered in the small box below.