I have a report in BEx 7.0 which displays the Orgunit wise Employee Head count for the month Interval entered by the user. The 0EMPLOYEE is a time dependent charecteristic. For calculating the head count i have created a formula variable as:
Type: replacement path
Ref charecteristic: 0EMPLOYEE
Replace variable with: InfoObject and Charecteristic Reference (Constant 1) with the Calculation After Calculation.
Each employee has an Orgunit as an attribute.
Now when i run the report for period: 01.2010 to 07.2010 it does give me a count but for employees who have changed their orgunit's in this period the report counts it as two. Which should actually be 1 since its a single employee with just a change in Orgunit.
Can you please suggest.