AnsweredAssumed Answered

Behavior of an empty numerical calculation field during search

Question asked by DavidConner1321 on Jun 28, 2011
Latest reply on Jun 28, 2011 by DavidConner1321

Title

Behavior of an empty numerical calculation field during search

Post

I was hoping for some insight into the following issue.

I am working with Filemaker 11 Advanced.

I have a table with a calculation field using the Sum(field) calculation. The result is set to number and sums values from related number fields. Depending on the related field the result may be a decimal number or nothing (i.e. no related fields so no value). The numerical value from the calculation is correct. However, I have problems when performing searches on that field. For example, I can find all the values that are >0. However, the search fails if I search for all records with no value (=), even though there are many records with no value. 

I have tried changing the calculation to a conditional calculation that results in 0 if the Sum(field) calculation does not result in a value greater than 0. The expected result is displayed, but the search still fails. For example, if I search for values that are <= 1, it returns all records with 1, but not those records in which the value is 0. I have double-checked to make sure all the related fields are defined as number fields. I had thought originally that it may have been a text vs. number issue.

Any ideas? 

Outcomes