Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use Set Analysis for a not equal to value.
=Sum({$<[Flag]-={'x'}>}[Amount])
This is not working properly. When I change -= to just = , I get the correct amount for the ones that should be equal to x. How should I write this to sum the Amount where the Flag is not equal to x?
May be
Sum(If(Len(Trim(Flag))=0,Amount)
=Sum({$<[Flag]= e({1<id={'X'}>})>}[Amount])
try this
corrected one
try this please
=Sum({$<[Flag]= e({1<[Flag]={'X'}>})>}[Amount])
Am I right ?
=Sum( {1- $<[Flag]={'x'}> } [Amount] )
Hi Cliff,
May be try,
=Sum({$<Flag ={'*'}-{'x'}>}[Amount])
Hi , you need to change from " -= " to " =- " and it will work.
=Sum({$<[Flag]=-{'x'}>}[Amount])
Indeed, it all depends on what should be the initial selection:
However, from the OP we cannot deduce in detail what is the initial situation...