Not include current selection

[Anonymous]

Hi all,

I'm wanting to show all units apart from those that have been bought from buyer that is currently selected.

My expression although it is wrong is,

if(BUYER.B_NO = GetCurrentSelections , '', BRANCH_NAME)

Could anyone give me a hand please?

Thanks

Gareth

[sunny_talwar]

I am guessing you want to use this within some kind of expression, if that's right try this:

{<BUYER.B_NO = e(BUYER.B_NO)>} or

{<BUYER.B_NO -= p(BUYER.B_NO)>}

[MK_QSL]

Considering Buyer is the Dimension

Count({<units = e(units)>}DISTINCT units)

[stigchel]

Try with

if(BUYER.B_NO = GetFieldSelections(BUYER.B_NO),null(),BRANCH_NAME)

[Kushal_Chawda]

something like this

count({<BUYER.B_NO =e({<BUYER.B_NO={"=getfieldselections(BUYER.B_NO)"}>})>}BRANCH)

[#6 · Accepted solution]

Hi,

PFA the demo app, you can change the condition as required.

E(), its basically exclusion.

Regards,

Navdeep

[Anonymous]

Thank you for your help everyone!

[MK_QSL]

I have also given the same expression !

[Anonymous]

Excellent Manish, well done