Not sure what your question is. But I will make two suggestions:
1. Review your structure: having 16 fields of the same type usually indicates a design flaw; those fields should probably be records in a related table.
2. Do not use $variables in a calculation field.
Thank you for the response.
These particular 16 fields in each record could have 14 or more separate values.
(The 16 fields need to be reported in sequence within each record)
I just want to count the number records that do NOT have "NO ERROR" or "----" in all of the 16 fields within a found set.
Any reference or suggestion is appreciated.
Well, you could try something like =
all = List ( ERROR_1 ; ERROR_2 ; ERROR_3 ; ... ERROR_16 )
not ValueCount ( FilterValues ( "NO ERROR¶---" ; all ) )
My suggestion in point 1 still stands.
I appreciate your suggestions and will use them.