2 Replies Latest reply on Aug 14, 2015 6:39 AM by Stu412

    ExecSQL maths?

    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