2 Replies Latest reply on May 24, 2013 1:44 AM by Celvin Kattookaran

# Calculation Script to Pull Distinct Employees

Hi All,

I have to count number of Billed Employees.For this i have data like

E1,G5,P_1,TRAVEl,North America,N,Allocated,6.78
E1,G5,P_2,BFS,No_Entity,Y,Allocatied,14.02
E1,G5,P_3,INSURANCE,North America,Y,Allocated,33.77
E1,G5,P_4,MUN,North America,N,Allocated,1.08
E1,G5,P_5,TRAVEl,North America,N,Allocated,3.08
E1,G5,P_6,TRAVEl,North America,N,Allocated,6.78
E1,G5,P_7,No_Vertical,No_Entity,N,Allocated,27.32
E1,G5,P_8,No_Vertical,No_Entity,N,Allocated,6.78
E1,G5,P_9,CRN,North America,N,Allocated,0.38

A Particular Employee is Allocated to different projects in which some are Billability "Y" and some are "N".
I want to add a member in Account dimension like Billed_Count to be taken as 1 if the Employee having Billability "Y" in atleast one Project for Distinct Employee. I have to see overall headcount of Billed Employees at different head levels like Grade wise, Project wise, Vertical wise...

How can i overcome this scenario. I tried in different combinations but i haven't get what i expected. Please help on this.

Regards,
Chinnu
• ###### 1. Re: Calculation Script to Pull Distinct Employees
Use count with in Fixes as per your requirement and have a look at below post:
How to get the Employess count ?? in the calculation  script

Cheers..!!
Rahul S.
• ###### 2. Re: Calculation Script to Pull Distinct Employees
In the example E1 has two Ys so will the account be 1 or 2?

Count is an option that you can look at.

Your explanation is little confusing is that distinct Employee for each project or distinct project for each employee?

Regards

Celvin
http://www.orahyplabs.com