Aggregate Queries in mysql using virtual fields

I have created a virtual field vcol1 for SUM query as mentioned in want to use dreamfactory api to query.

SELECT col0,SUM(col1)
FROM tablename
WHERE col2=x
I get a value 0 for all records.Any help?

Hi Kyle, maybe if you give more details, i.e. how are you doing the call I could help you to get it running.