Calculations

rbuser

Hi, newbie novice user here. I have a question on performing calculations.
I have a report in code with alias database fields placed on it. I wish to
use the "Expression" capability which is available in "end-user" -- and not
"code" the calculation as a variable. I can sum one field on the report
(sum field1), but I can not add field1 to field2 because expression is not
available. Did I not install RB properly?? Why can I use expression in one
place (end-user) but not another.

Also, is there a new end-user manual that does not contain documentation on
code?

Thanks in advance.
Diana Cardillo
dianac@creativeautomation.net

nicocizik

Hi Diana,

I believe this is a limitation of SQL itself. You cannot use an existing
aggregate function's field alias inside another aggregate function. As an
alternative, you could make a larger expression that includes the first
function. Something like: SUM(Field1) + Field2 in the expression field
should work. Let me know if this helps, or if I'm completely
missunderstanding the issue.

--