Vincent_L

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

Discussion created by Vincent_L on Dec 5, 2014
Latest reply on Dec 8, 2014 by gdurniak

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)

Outcomes