I created a discoverer report which shows Salary Amt, Travel Amt for each employee, period. I wanted to show the total salary cost & total travel cost in the last row.
When I use the Grand Total under Tools > Total (sum or cell sum), the last row always shows zero.
Any ideal why it happens and how it can be handled?
The folder query is:
SELECT EMPLOYEE_NUMBER, PERIOD_NAME,
SUM(NVL(SALARY_AMT,0)) AS SAL_AMT,
SUM(NVL(TRAVEL_AMT,0)) AS TRAVEL_AMT,
'USD' as currency
( SELECT EMPLOYEE_NUMBER,
DECODE(CATEGORY, 'SALARY', PERIOD_NET_USD) AS SALARY_AMT,
DECODE(CATEGORY, 'TRAVEL', PERIOD_NET_USD) AS TRAVEL_AMT
FROM APPS.DISC2_GL_JE_CONSOLIDATE_ORG )
GROUP BY EMPLOYEE_NUMBER, PERIOD_NAME
Thanks in advance.