I have a simple database which uses 4 fields as shown below:

 

I have Trailing Subtotals set for each column (except Agent). The problem is that the Totals column does not produce the correct total - it's very close but NOT correct. For example, Pay1 may show $500, Pay2 may show $350, and Totals may show $843.46 instead of $850.

 

I have a Microsoft Access program which does the same calculations correctly. Suggestions greatly appreciated. Note, I'm far from an expert when it comes to Filemaker.

 

 

Agent  Pay1  Pay2  Totals

I think we need more information then that. Either attach a copy of file Attach a File. or post a copy of your calculation you are using, and / or a screen shot.

 

I moved your topic from "FileMaker Pro 12" to "Calculation Engine (Define Fields)” because the General Topics are for discussion of the new tools, functions, features introduced with that release of FileMaker, and not for asking how-to questions..