Set Analysis Excluding 2 Values within 1 field

[Bnm03080]

Hello and thanks in advance!

How would I write a set analysis excluding 2 values within 1 field?

[Mauritz_SA · Accepted solution]

Hi @Bnm03080 

Something like this should work:

Sum({<[Your field] -= {'Excluded value 1','Excluded value 2'}>} [Field you want to sum])

Hope it helps.

Regards,

Mauritz

[msKarthikeyan]

Hi 

can you explain what is your requirement?

-Karthik

[Bnm03080]

Thank you!