4 Replies Latest reply on Jul 8, 2011 2:01 PM by philmodjunk

    Calculation returning wrong results when made through IWP.

    MartinRochefort

      Title

      Calculation returning wrong results when made through IWP.

      Post

      OS:  Mac 10.5.8

      FMP v11

      Hello.  Here is my page setup.  It is for calculating the length of time it takes for a project to complete.

      Employes will push a button in the plant through IWP which activates a timestamp.

      There are 4 sections for each of three projects.

      At the end of each section the total time is calculated.

      At the end of the 3 projects the grand total of the time it took to complete all of the three projects is calculated.

      Everything works fine on the host computer.  The problem occurs when using IWP from a computer in the plant.  As each button is pushed, the 3 subtotals work fine.  However the grand total will return a wrong sum on some occasions.  It is a simple calculation of the 3 subtotals with a 'Case' to exclude results<0.  The incorrect results are returned on the host computer as well when submitted.

      Here is my calculation.  Case (Time 1 Total + Time 2 Total + Time 3 Total  ≥ 0; Time 1 Total + Time 2 Total + Time 3 Total)

      Everything is fine when using the host machine.

      Any help is greatly appreciated.

      Picture_1.png