Set Analysis for Less than Equal

[#1]

Can someone assest me with the Set Analysis for the following fields and varables? It seems so simple and yet all the discussions make it so hard.

EmployeeDirectory.DOH <= vLastYear

[CELAMBARASAN]

For and conditions you have to use like below

=Count({<DOH_Year = {'<=$(=vLastYear)'}>*<NLE_Year = {'<$(=vLastYear)'}>}Distinct EmployeeName)

It gives you the employees hired <= last year and not here in Last year

[CELAMBARASAN]

I didn't understand your conditions and requirements?Do you need the employees leaved from office last year?

[#4]

I want everyone who was an employee at the end of year 2011. NLE is No Longer Employeed

[CELAMBARASAN]

=Count({<DOH_Year = {'<=$(=vLastYear)'}>*<NLE_Year = {'>$(=vLastYear)'}>}Distinct EmployeeName)

[#6]

When I do this I get Zero's. Can you explain what the * is between the two set analysis? And would the NLE_Year be not equal to vLastYear?

[#7]

Mayil Vahanan Ramasamy

Your calculation worked except it didn't count the blanks from the database, which I want included because they were here at that time. Any ideas why it doesn't count them?

[MayilVahanan]

Hi,

     By celambarasan concept is correct,

     =Count({<DOH_Year = {'<=$(=vLastYear)'}> *< NLE_Year = {'<$(=vLastYear)'}>}Distinct EmployeeName)

      it checks both, who are all in last year in DOH_Year and NLE_Year also...but exclude the person in last year in NLE_Year..

Can you test like this,

=Count({<DOH_Year = {'<=$(=vLastYear)'}>}Distinct EmployeeName)

=Count({<NLE_Year = {'<$(=vLastYear)'}>}Distinct EmployeeName)

And Then check like this, before that verify the data manually, if any one is satisfy the following condition..

=Count({<DOH_Year = {'<=$(=vLastYear)'}> *< NLE_Year = {'<$(=vLastYear)'}>}Distinct EmployeeName)

Which is mentioned earlier, gives exclude the person , who are below the last year in NLE_Year and include the person who are in present year and DOH_Year <= vLastyear..

Hope you understand the expression..

[#9]

Mayil,

Both expression's return all zeros. So it look likes because the first expression is failing for some reason. Any ideas why?

=Count({<NLE_Year = {'<$(=vLastYear)'}>}Distinct EmployeeName)

=Count({<DOH_Year = {'<=$(=vLastYear)'}> *< NLE_Year = {'<$(=vLastYear)'}>}Distinct EmployeeName)

[#10]

Hi Celambarasan,

Does the >*< mean AND? Does the comma do the same thing?

=Count({<DOH_Year = {'<=$(=vLastYear)'},NLE_Year -= {'<$(=vLastYear)'}>} EmployeeDirectory.Name)

=Count({<DOH_Year = {'<=$(=vLastYear)'}>*< NLE_Year -= {'<$(=vLastYear)'}>} EmployeeDirectory.Name)

[MayilVahanan]

HI,

   Did you check the NLE_Year values..

=Count({<NLE_Year = {'2010'}>}Distinct EmployeeName) gives any value..By check this, you can find the error..