AnsweredAssumed Answered

ExecSQL maths?

Question asked by Stu412 on Aug 14, 2015
Latest reply on Aug 14, 2015 by Stu412

Title

ExecSQL maths?

Post

If I have a data table which is simply:

Amount      cCalculatedValue     cCalculatedValue2

I can do a ExecuteSQL calculation like this to display a value:

Select SUM (Amount) where.....

However, I can't seem to do:

Select SUM (cCalculatedValue)/Sum(cCalculatedValue2)

or for that matter, I can't even get;

Select SUM (cCalculatedValue_ where....

Why is this?

Thanks

 

Outcomes