WebDirect fails simple addition
Operating system version
Windows Server 2008 R2 Enterprise
Description of the issue
Calculated fields do not add up everything in WebDirect.
I am attaching a document so you can see what is happening (see items highlighted in red). If I run a report in FMP client the calculated fields add up from 5 or 14 other summary fields and give the correct answer. If I go into the DB from WebDirect and run the report, the calculated fields on the first row do not give the correct answer. I have manipulated the underlying data to have 1's in the other Event fields for this summation, and still get an incorrect answer on the top row.
Another issue is that the calculated rate field in this top row/column does not calculate at all from inside WebDirect.
Steps to reproduce the problem
Multiple Summary fields that are then added together to get a total of the summary fields. The formulas work fine in FMP client, but not in WebDirect
Add up the fields correctly
does not do the correct addition
Exact text of any error message(s) that appear
Haven't found one