Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Count({1-$(=GetFieldSelections([ Name]))}Distinct If([Flag]=1,[userid]))
I am getting error in this expression where i am trying to get the values other excluding the selected filter(NAME)
The error message is correct. Your set expression is invalid:
{1-$(=GetFieldSelections([ Name]))}
Not sure what you are trying to achieve here... Is the $ supposed to be the first part of a dollar expansion? Or is it supposed to be part of the set syntax, denoting current selection?
$ representing the value of the current selection ( ( 1 - $) i represent to get values other than the selected name
The following will return current selection, but instead of the selected values of "Name", it will use the excluded ones: {$<Name=E(Name)>}
However, if you don't have any selection in "Name" it will return the empty set. Perhaps better to use {1<Name=E(Name)>} ?
If you instead use {1-$<...>} it will return ALL excluded rows, also those that are excluded by other selections.
=Count({1<([Name]=E[Name]>})[ReportName])
I tried this but again i am getting set modifier expression error
Check your brackets. E() - not E[].
=Count({1<[Name]=E([Name])>}[ReportName])
is not giving me errors ,but the value is not changing when the filter is applied