Condition differently in the Set analysis

[warrentk80]

Goodmorning everyone

I need to enter in a formula by Set analisys to select data other than a given value

the syntax that normally use to control "if equal" is sum ({$ <[Flg Activity Type] = {'F'}>} [Total power consumption in €])

but if I have to select data other than F does not work the formula

sum ({$ <[Flg Activity Type] <> {'F'}>} [Total power consumption in €])

someone would know how to say it uses the Set analysis on the condition differently?

Thank you

Andrea

[MK_QSL]

({$ <[Flg Activity Type] -= {'F'}>}

[sunny_talwar · Accepted solution]

or this if you don't want your expression to change based on a selection in [Flg Activity Type] and always include everything except F

({$ <[Flg Activity Type] = {'*'}-{'F'}>}