Hi All,
I am working on BEx 3.5.
In one of my queries I am facing a problem.
I have hours, amount and no of employees in column
Hour1 Hour2 Amount No of Employees
20 20 180 1
20 20 0 1
20 20 20 1
I am displaying a hierarchy built on employee
I have given a condition in my query
Amount > 0
when the report is executed the report output comes as:
Hour1 Hour2 Amount No of Employees
60 60 200 2
I want to eliminate the addition of hours.
It should be,
Hour1 Hour2 Amount No of Employees
40 40 200 2
Please help me in finding a solution.
Thanks,
Rashmi.