Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'}>}
({$ <[Flg Activity Type] -= {'F'}>}
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'}>}