Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like this,
sum({<Advisors-={'BOB'}>}Sales)
try like this
sum({<Advisors={"*"}-{'BOB'}>}Sales)
Hi,
PFA basics set analysis PDF document may be useful for you.
or this:
sum({$-<Advisors={"BOB"}>} Sales)
Hello,
Try this:
sum({<Advisors=e({1<Advisors={"BOB"}>})>}Sales)
P() & E() and where do you use them?
Regards
Jacek.
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).