There appears to be no test of rn or r2.
From the syntax, Cable Ratings Data Source::Rating and OPD Ratings Data Source::Rating are fields from a related table. What relationship do you have linking to that table? Is the relationship valid? Is the "table occurrence context" for this calculation correct?
Table Occurrence Context:
All calculations that reference data in related tables evaluate from the context of a specific Tutorial: What are Table Occurrences? box in Manage | database | Relationships. This 'starting point' then determines what relationship and what match fields that define that relationship will be used to access a specific record in the related table. If you change the "context", a different relationship may be used by Filemaker to access the data in the related table.
In the case of calculation fields and auto-entered calculations, there's a "context" drop down in the specify calculation dialog where you can select by name any occurrence of the table in which you are defining the field. In some calculations, you may need to carefully study your relationship graph in order to figure out the correct context to specify for your calculation. In the case of calculations in script steps, calculations in portal filters and in conditional format expressions, the table occurrence specified in "show Records from" in Layout Setup of the current layout determines the table occurrence context.
Wow that was fast
I meant to colour my last post. The problem is in the `or` statement. Fault does not occur if number is in r1. But LIM is ignored.
Vice versa if I transpose
I suspect its a bracket issue
I've been playing with this expression in my data viewer (A filemaker advanced tool).
r1 ≠ LIM or Number
and rn ≠ LIM or Number
and r2 ≠ LIM or Number
mean that the only acceptable value for r1, rn and r2 is "lim"?