AnsweredAssumed Answered

Search error: search a text calculation result

Question asked by hoapenncho on Jul 7, 2018
Latest reply on Jul 7, 2018 by hoapenncho

Dear all,

 

I had a problem on search my text calculation result.

 

I have a calculation field called "reported". If the filed "No. of reports" is not 0, then "reported" = "yes". if no reports, then "reported" = no. So the code for "reported" field is like this:

 

Case (

No. of report ≥ 1;"Yes";

No. of report =0;"No";

)

 

Realy simple and it works.

 

However, when I search the "reported" field with "No", it will say "no records match this find criteria". If I search "yes", then both the records of "yes" and "no" will be found. Frustrated. Please help me. Thanks!

 

I am using the filemaker Pro 15 mac version.

Outcomes