Can you give some more info or a demo file?
Incorrect in what way? What do the calcs do: list, count,...
In the following example, we have three related tables: Assignment, Invoice and InvoiceLines.
We are searching in the field “TotalRemainingInvoice” on a layout based on Assignment.
Searching for 110,000 in “TotalRemainingInvoice” will also find 0 and other values. The strange thing is that many of assignment-records (but not all) are containing 110,000 as AssignmentPrice, but it seems to skip a part in the formula? (it doesn't make any sense)
When we restart the FileMaker Server 12 computer the searches works fine again for a while (3 to 7 days).
Assignment::TotalRemainingInvoice [Calculation, number] =
Truncate ( AssignmentPrice - Sum(Invoice::PriceMUAmountSum) ; 0 )
Invoice::PriceMUAmountSum [Calculation, number] =
InvoiceLines::PriceMUAmount [Calculation, number] =
If(GroupCode = "Consult." ; Price ; "" )