Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guyz i have
Count(Distinct Num_Employee)
and i want previous selection for this
i tried using
Count({$1} Distinct Num_Employee)
but its not working.
Can anyone please suggest me solution, better if it is set analysis
try count(Distinct {$1} Num_Employee)
nope thanks...already tried...
Both the expressions work as in the attached app.
Count({$1} Distinct Num_Employee)
count(Distinct {$1} Num_Employee)
The reason for the error could be because of no previous selections.
SC
works on my end...what error or result do you get?
Error can make some problem...can you put this in set analysis and let me know?
have you check the app. Yours and jsaradhi's expressions are working fine.
Syntax Error.... Red line under the curly bracket
Hi,
Not having a previous selection should not give an error, it just results in Zero value. As you said, both expressions should work as expected. If syntax is underlining some part of the formula then it may be something else,
regards
Red line under curly bracket doesn't always mean the expression is not correct. Not having a previous selection should not throw an error.