Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Larisa, you can use:
sum ({<Categories = Categories-{'Category1'}>} [Budget])
or
sum ({<Categories -= {'Category1'}>} [Budget])
or
sum ({<Categories = {"*"}-{'Category1'}>} [Budget])
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.
sum ({<Categories -= {'Category1'}>} [Budget])
-= instead of =
Hi Larisa, you can use:
sum ({<Categories = Categories-{'Category1'}>} [Budget])
or
sum ({<Categories -= {'Category1'}>} [Budget])
or
sum ({<Categories = {"*"}-{'Category1'}>} [Budget])