2 Replies Latest reply on Mar 22, 2014 4:53 AM by stefaubry

    Weird result with ExecuteSQL

    stefaubry

      Filemaker return bad result with the sum function in a ExecuteSQL, the result is wrongly multiplied by 10 or 100

       

      My request is

       

      ExecuteSQL ( "Select sum("SousTotalUseCopy") From "Facture" where ("YYYY"=?) and ("RegionCopy"=?)"; "" ; "" ; YYYY;RegionNumber )

       

       

      on those data

      -44.4

      122.4

      77.6

       

      the result is 1556.00 (instead of 155.60)

       

       

      on those Data

      -7.3

      25.32

      15.12

       

      I obtain 3314.00 (instaed of 33.14)

       

      my result if multiplied by 10 or 100 depending on how many decimal after the dot

       

      any insight on what happening?

       

       

      Thanks