Calculating the head count base on the selection

[nizamsha]

Hi All,

I Am Facing the Issue for calculating the headcount based on the selection .Here by attached the sample xls .please provide solution me

[#2]

If you didn't specify any condition by default it will give value according to current selection only.

try count(ID). this will give you the value for your current selection.

[nizamsha]

Hi All

For calculating the head this what i done and this what is in excel

3 column i have

Let vStartDate=MakeDate(2014,1);

Let VMinDate=MonthEnd(Today());

EMPID,

DOJ,

Termination,

For startdate i have a condition like this if(DOJ< vStartDate,vStartDate,DOJ) as StartDate

for EndDate i  Have Comdition like this if(len(Term Date)=0, vEndDate,Term Date) as EndDate

for end date i dont want to take to an consideration who got terminate before the start year i only want to check active ones

after getting the startdate and enddate i want to generate a random month between startdate and enddate for the employee and also create a status 1 if he is active if he is not active mean 0

[vikasmahajan]

Did you got solution??????????

Vikas