question about set expression

[Anonymous]

Hi,

If I need to calculate the Budget for Category 1 only I can use the following expression:

sum ({<Categories = {'Category1'}>} [Budget])

But my task is to calculate quite the opposite - all other categiries except Category1.

How should I change this expression so that I could calculate the Budget for all other Categories except Category1?

Thank you in advance,

Larisa Filonova

[#2]

sum ({<Categories -= {'Category1'}>} [Budget])

It'll give you a syntax error but ignore it, syntax checker doesn't like the -= part even though it works fine.

[maleksafa]

sum ({<Categories -= {'Category1'}>} [Budget])

-= instead of =

[rubenmarin1 · Accepted solution]

Hi Larisa, you can use:

sum ({<Categories = Categories-{'Category1'}>} [Budget])

or

sum ({<Categories -= {'Category1'}>} [Budget])

or

sum ({<Categories = {"*"}-{'Category1'}>} [Budget])