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?