10 Replies Latest reply on Dec 8, 2014 4:07 AM by gdurniak

    Help : Can't do math operation with SUM in FQL ?

    Vincent_L

      Hi,

       

      Do you know why the code below deosn't work ? of course all fields are defined as numbers

       

      ExecuteSQL ( "SELECT sum(thevalue)*2 FROM records GROUP BY themonth" ; "" ; "" )

       

      ExecuteSQL ( "SELECT sum(thevalue) FROM records GROUP BY themonth" ; "" ; "" ) works ok

       

      This works perfectly fine in mysql

       

      I don't want to write sum(thevalue*2)