AnsweredAssumed Answered

Weird result with ExecuteSQL

Question asked by stefaubry on Mar 22, 2014
Latest reply on Mar 22, 2014 by 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

Outcomes