Extra hours being populated in report

[Former Member]

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.

[Former Member]

I had to move my query from 3.5 to 7.0 to have exception aggreagtion.

[Former Member]

I can not restrict condition to employee as employee is a characteristic on which hierarchy is built.

Thanks,

Rashmi.

[Former Member]

Hi

Restrict your condition to emploee then it should work.

Regards,

Chandu.