5 Replies Latest reply on Sep 15, 2009 10:03 AM by gberg927

    No Records Match when searching in calculation

    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.