Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')
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')
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')
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')
Many Thanks Rubenmarin
Many thanks Somasundaram