scottyjohn
Technical User
Hi all,
I have a query which runs against one table and the query I am attempting looks like this....
SELECT
SOFTPHONE.BRAND,
Count(SOFTPHONE.BRAND) AS CountOfBRAND,
ROUND(Avg([SOFTPHONE].[TT])) AS AVGTT,
ROUND(Avg([SOFTPHONE].[HT])) AS AHT,
ROUND(Avg([SOFTPHONE].[ACWT])) AS AVGACW,
Avg(Sum([TT]+[HT]+[ACWT])) AS AHT
FROM SOFTPHONE
GROUP BY SOFTPHONE.BRAND, Avg(Sum([TT]+[HT]+[ACWT]));
After adding the calculated column AHT, I get the error back "cannot aggregate function in expression" Im assuming that it doesnt like me trying to average a sum?
Also when I try to just get the sum of the three columns TT HT and ACWT, using [SOFTPHONE]![TT]+[SOFTPHONE]![HT]+[SOFTPHONE]![ACWT], I get a cocatenation of those fields rather than an added total. I dont understand what is going on. can anyone help?
John
![[smile] [smile] [smile]](/data/assets/smilies/smile.gif)
I have a query which runs against one table and the query I am attempting looks like this....
SELECT
SOFTPHONE.BRAND,
Count(SOFTPHONE.BRAND) AS CountOfBRAND,
ROUND(Avg([SOFTPHONE].[TT])) AS AVGTT,
ROUND(Avg([SOFTPHONE].[HT])) AS AHT,
ROUND(Avg([SOFTPHONE].[ACWT])) AS AVGACW,
Avg(Sum([TT]+[HT]+[ACWT])) AS AHT
FROM SOFTPHONE
GROUP BY SOFTPHONE.BRAND, Avg(Sum([TT]+[HT]+[ACWT]));
After adding the calculated column AHT, I get the error back "cannot aggregate function in expression" Im assuming that it doesnt like me trying to average a sum?
Also when I try to just get the sum of the three columns TT HT and ACWT, using [SOFTPHONE]![TT]+[SOFTPHONE]![HT]+[SOFTPHONE]![ACWT], I get a cocatenation of those fields rather than an added total. I dont understand what is going on. can anyone help?
John
![[smile] [smile] [smile]](/data/assets/smilies/smile.gif)