No Records Match when searching in calculation
I have a calculation field reading data from a separate (but related) table. The thing is whenever I do a find for something in that field, it returns no results. Is this just an issue with FMP and calculations or am I doing something wrong?
Here is the calculation of the field.
If(NTW Index::ntwStatus="On-Campus Active" or NTW Index::ntwStatus="Off-Campus Active" or NTW Index::ntwStatus="RAMCare Active" ;NTW Index::ntwStatus;"Non-NTW")
All help would be appreciated.