What does $ meaning in set analysis, and how to make set analysis respond to a filter?

[Edge]

Hi All,

1- What is the meaning of dollar sign in the below expression?

=num(count(distinct {$<[Student Status]={$(='New')},Location={'AA'}>}Enrolment.EMPLID),'#,##0')

2- If I have a filter for the location and I choose another location the above doesn't show a value of zero. How can I do that?

Many Thanks in advance.

[Somasundaram · Accepted solution]

Hi,

1. Set Analysis "$" means Current selection.

2.In the set expression, you have mentioned Location as 'AA'. so it will not show for another location.

Use this expression, You will get the value based on the location selected in filter

=num(count(distinct {$<[Student Status]={$(='New')}>}Enrolment.EMPLID),'#,##0')

[rubenmarin · Accepted solution]

Hi, the dollar in $(='New') is called $-expansion, it eavluete the values inside the parenthesys and returns the result to create the expession, in this case it will be the same as "[Student Status]={'New'}"

2- To show zero you can use the * operator to look for union between selections and fixed value(s):
=num(count(distinct {$<[Student Status]={$(='New')},Location*={'AA'}>}Enrolment.EMPLID),'#,##0')

[Edge]

Many Thanks Rubenmarin

[Edge]

Many thanks Somasundaram