exclude values of current selection in set analysis

[nehasaxena]

Hi All,

I have a requirement to display the count of team members for all the managers other than selected manager.

I have written this expression - Count(DISTINCT{<manager-={'$(VGetManager)'}>} memberid)

Variable VGetManager = GetFieldSelections(manager)

But this is working exactly opposite. If i select manager name than it gives me count of members associated with that manager. I want the count of not associated members.

I read about P and E function but not understand how to use in my case.

Please suggest the expression.

Thanks.

Regards,

Neha

[dsharmaqv]

try this

Count(DISTINCT{<manager={'*'}-{'$(VGetManager)'}>} memberid)

[#3]

Hi,

Use '1-$' in place of '$' this will give you excluded results,

Thanks

[tresesco]

Try like:

Count(DISTINCT{<manager=-$::manager>} memberid)

[praveenak]

Hi Neha,

Try the below expressions,

count({$<manager=E({<manager={$(=getfieldselections(manager))}>}manager)>}memberid)

Thanks

[vinieme12]

just this will do

Count(DISTINCT{<manager=E(manager)>} memberid)

[praveenak]

Hi Vineet,

Not an offense but your expression will show 'No data to display' when there is no selection made in the filed 'manager'

Thanks

[vinieme12]

None taken; but there is no need to complicate it unnecessarily it's for the OP to decide what he want

[nehasaxena]

Thanks Vineeth. I used this because we want to show data only when manager is selected.

[nehasaxena]

This expression is not working