Are your other fields part of a table? If not, you may have to call each of them individually. Something like:
var t = 0 if (field1 > 36) then t=t+1 endif if (field2 > 36) then t=t+1 endif if (field3 > 36) then t=t+1 endif if (field4 > 36) then t=t+1 endif t
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.
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.
var t=0 if (taxCollectorCustomerSatifaction.tfMid > 36) then t=t+1 endif if (telephoneSurvey.tfMid > 36) then t=t+1 endif //more lines for the rest of the table t
if (CustSatisfaction1.tfMid > 97) then t=+1 endif
if (TelephoneSurvey1d.tfMid > 97) then t=+1 endif
FormCalc doesn't recognize the =+ operator. You'll have to write it out. FormCalc will treat it as t = "+1" and output that at the end.
Thank you, please forgive me for sounding ignorant, but this is only the second form I've built using FormCalc and LiveCycle.
How exactly would I need to write it out. That is the part I don't know.