Excluding a dimension in an expression

[tim_leijen]

Hi guys,

Currently I'm trying to exclude a dimension in an expression.

I was told this would work with the "-" sign in front of the dimension, however I get an error.

Not sure what I'm doing wrong though

gr

[tresesco · Accepted solution]

Try like:

=Sum({<GL_1={NSV}, Dimension=- {RFC}>} Data)

If you still get an error, ignore it (it's a known issue) and go ahead.

[devarasu07]

Hi,

Try like this

sum({<GL-l={'NSV'},Dimension-={'RFC'}>}Data)

[tim_leijen]

Thanks! Allthough it still shows an error, it does work

[Kushal_Chawda]

you have syntax error in your set analysis. See the below

A Primer on Set Analysis‌

Why is it called Set Analysis?