Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Extra hours being populated in report

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
Not what you were looking for? View more on this topic or Ask a question