how to adjust group by clause in query
Hi how to prevent query manager from automatically adding the expression - (SUM( SUM( A.POSTED_TOTAL_AMT))-SUM( SUM( B.BUDGET_AMOUNT)))"VARIANCE" to the group by clause SELECT (SUM( SUM( A.POSTED_TOTAL_AMT))-SUM( SUM( B.BUDGET_AMOUNT)))"VARIANCE", A.DEPTID, B.DEPTID, SUM(POSTED_TOTAL_AMT), SUM( B.BUDGET_AMOUNT) |