AnsweredAssumed Answered

No Records Match when searching in calculation

Question asked by gberg927 on Sep 14, 2009
Latest reply on Sep 15, 2009 by gberg927

Title

No Records Match when searching in calculation

Post

Hi,

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.

Outcomes