I need to query a series of custom fields and total the number of times the answer “Achieved” was entered. Unfortunately, I’m not able to alter the schema that has been developed for storing this information. I have not been able to find a way to count the “Achieved” responses without triggering the nesting of 101 is too deep error. I’ve attempted the following functions, separated by “OR”s:
In some cases, we have more than 170 of these specific fields that will need to be queried and talied. What would be the best method of accomplishing this?