Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Set Analysis for Less than Equal

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

1 Solution

Accepted Solutions
Partner - Champion

Try this

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

26 Replies
MVP

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

Thanks & Regards, Mayil Vahanan R
Partner - Champion

Try this

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

Not applicable
Author

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

Not applicable
Author

How does this look I think you forgot the quotes

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

MVP

HI

For less than or equal to

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

Hope it helps

Thanks & Regards, Mayil Vahanan R
Not applicable
Author

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.

MVP

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?

Thanks & Regards, Mayil Vahanan R
Not applicable
Author

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?

MVP

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)

Thanks & Regards, Mayil Vahanan R