2 Replies Latest reply: May 23, 2013 8:44 PM by Celvin Kattookaran RSS

    Calculation Script to Pull Distinct Employees

    926624
      Hi All,

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

      Employee,Grade,Project,Vertical,Entity,Billability,Account,Data
      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.

      Thanks in Advance,


      Regards,
      Chinnu