Set analysis for sales

[aaronnayan]

Hi Guys

I need an expression to exclude a certain value from the selected field whilst calculating sales

Can you help?

the field is "Advisors"

the value is "BOB"

Sales field is "SALES"

Thankyou guys

[devarasu07 · Accepted solution]

Hi

Try like this,

sum({<Advisors-={'BOB'}>}Sales)

[avinashelite]

try like this

sum({<Advisors={"*"}-{'BOB'}>}Sales)

[devarasu07]

Hi,

PFA basics set analysis PDF document may be useful for you.

[Anonymous]

or this:

sum({$-<Advisors={"BOB"}>} Sales)

[Anonymous]

Hello,

Try this:

sum({<Advisors=e({1<Advisors={"BOB"}>})>}Sales)

P() &amp; E() and where do you use them?

Regards

Jacek.

[sam_grounds]

Yeah, I can confirm this totally works, however syntax highlighting doesn't like it and you'll get the dreaded red squiggly underline!

If you want a syntax friendly version try sum({$-$<Advisors={'BOB'}>}Sales).