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

[MayilVahanan]

Hi

     What you are trying to calculate?

     For example:

     =Count({<EmployeeDirectory.DOH = {'$(=vLastYear)'}>}Distinct EmployeeName)

     Edit:

     For less than or equal to

     =Count({<EmployeeDirectory.DOH = {'<=$(=vLastYear)'}>}Distinct EmployeeName)

     Hope it helps

[CELAMBARASAN · Accepted solution]

Try this

Sum({<EmployeeDirectory.DOH ={"<=$(=vLastYear)"}>} FieldName)

[#4]

That is correct but I want to make it Less than or equal too. Does that make since?

[#5]

How does this look I think you forgot the quotes

Count({<EmployeeDirectory.DOH = {$('>vLastYear')}>} EmployeeDirectory.Name)

[MayilVahanan]

HI

  For less than or equal to 

     =Count({<EmployeeDirectory.DOH = {'<=$(=vLastYear)'}>}Distinct EmployeeName)

Hope it helps

[#7]

I am calculatinig people who were here in 2011 and I look at

DOH_Year<=vLastYear  and NLE_Year<vLastYear

How do I change your expression to do this new calculation?

BTW your calcuation was correct for what I asked for but now I have to include people who were not here at that time as well.

Thank you in advance

[MayilVahanan]

HI,

     Is there relation between DOH_Year and NLE_Year? If so, use like this

     Edit:

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

     Can you post a sample file?

[#9]

NLE is "No Longer Here" and DOH is "Date of hired".

I get that it gets to be DOH_Year<= and NLE_Year <>vLastYear correct?

[MayilVahanan]

Hi,

Use like this,

     Is both Year field?If so

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

     Edit:

     Celambarasan solution solve your problem perfectly..I forget that..

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