Employee Count in Bex

[former_member344586]

Hi Guys,

I am having below scenario :

Emp , Item ,  Employee count  ( report columns )

When I execute query it shows me Emp Count as 20 , although the Employees displayed in Bex are only 19.

There is condition in this query , which filters out one employee.

I need to see the count of employee as 19 and the condition impact should not be there on employee count.

I have added Employee Count as calculated KF and put a constant value '1'  through variable.

Please suggest how can I achieve this.

Thanks !

[former_member344586]

Thanks Guys , for the replies !

Still getting the same result.

Below is the condition , I am applying :

Rate < 10    ( 10 comes from input variable from query )

I have used "employee" as reference characteristic , while creating condition.

For  Emp Count  , I have tried exception aggregation and used reference char as Employee.

but still the record which is filtered from the result as per the condition, adds into the emp count.

Also when I run the report for the employee which is not satisfying the criteria , I dont see the record for that employee , its blank report , but the count comes as "1" , for this execution.

Please suggest how to resolve if possible.

Thanks !

[D_Chia]

just to be clear ... the employee count has to be on each row (even though you are listing by employee) ?  or was the count of '19' in your example suppose to be on the total/result (yellow) line?

[former_member344586]

Hi Chia,

its overall result , not in each row.

Thanks!

[D_Chia]

ok. then what you need is to set the 'Calculations' -> 'Calculate Result As...' of the key figure's properties

set it to 'Summation'

[former_member344586]

Hi Chia,

If I do that  its adding multiple line items for same employee to the result.

so , If I have 29 , records in report , with 23 distinct employees , it shows result as 29.

I want to see count for unique employees.

Thanks !

[D_Chia]

now i get your predicament.  it it mainly due to the sequence between Condition's filtering vs the computation of the Exception Aggregation (Count in this case).

unfortunately BEx cannot (or won't?) run the summation just for result lines 'again' on the conditional filtered results

perhaps it's really easier (but with additional workbook/excel feature) to get the count from another view with just customer (no line items) and overwrite the last cell in your current result area.

[Former Member]

Hi Raju -

please find the below procedure from the screenshots . I hope this will resolve your issue.

Thanks..!

Regards,

Kumar

[former_member183012]

Hi Raju,

Can you please share what condition you applied in Bex?

Based on characteristic in report layout check the characteristic in condition and try it will show you proper result.

Regards,

Ganesh Bothe

[Former Member]

Hi,

I have added Employee Count as calculated KF and put a constant value '1'  through variable.

instead try exception aggregation on calculated keyfigure, also choose reference char as  employee, you should see employee count as 19 instead of 20.