Skip to Content

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

URGENT: Head count Last


I am using 0HDCNT_LAST Keyfigure,in which Excep.Aggregation is LAST VALUE but in my requirement if I take this, it is picking the last record of the employee. if the headcount of one of the employee is 0 and all other employees is 1 for particular 0CAL_DAY for eg:

There are 5 employee in organization

Employee 0HDCNT_LAST

1 1

2 1

3 1

4 1

5 0

Total employees headcount should be given as 4 for that calday

but it is giving as 0.

If any employee headcount is 0 inthat cal_day the total headcount is showing as 0.

I want to take both Last record of the employee and I need to get Total headcount of the employees..............?

PLease reply soon Its really urrrrrrrrrrgeeeeeeeennt

Not what you were looking for? View more on this topic or Ask a question