AnsweredAssumed Answered

WebDirect fails simple addition

Question asked by DSKatSCL on Oct 1, 2014
Latest reply on May 9, 2017 by TSGal

Summary

WebDirect fails simple addition

Product

FileMaker Server

Version

13.0.2.295

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.

Any Ideas?

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

Expected result

Add up the fields correctly

Actual result

does not do the correct addition

Exact text of any error message(s) that appear

N/A

Workaround

Haven't found one

WebDirect_Incorrect_Addtion_Results.png

Outcomes