How to use selected item within an expression?

[Anonymous]

I want to use a selected item in my expression but I am not having any luck.. Here is the expression:

=count(DISTINCT{<Capability_Level=GetFieldSelections(Capability_Level)>} Capability_Number)

The expression works if I hard code the Capability Level to equal a number but I want the users to be able to choose what Capability Level to look at.

[devyanshu_gupta]

Hi Kelly,

You don't need to use a set expression here. A normal filter would work here. Also in set analysis RHS is supposed to be in curly brackets.

Regards,

Devyanshu

[balabhaskarqlik]

=count(DISTINCT{<Capability_Level={'$(=GetFieldSelections(Capability_Level))'}>} Capability_Number)