Set Analysis Expression

[alec1982]

Hi Guys,

Anybody can tell me what's wrong with the below expression:

Sum({$<[Description] = {"*"} - {"Sold"}>}[Amount])

Thxs,

Alec

[alec1982]

Hi,

I am not able to load a sample but the issue is that the expression is not filtering based on the set analysis..

Sum({$<[Description] ={"*"}-{"Sold"}>}[Amount])

It is giving me all the total amount including the Sold items..

Best,

Alec

[alec1982]

Hi,

this seems to be working for me :

=Sum({$<[Description] = {'*'} - {"*Sold*"}>}[Amount])

Thxs for all your help!

[Anonymous]

Alec,

This expression is as good as the one I sent you, and should work the same way.  That is, it should exclude Amounts where Desription is equal 'Sold'.  Possible reason of not working:

- There are no records where Description='Sold'.  Use '*Sold*' to remove records where Description contains 'Sold'

- Data relations.  Canb't guess from here...

Regards,

Michael

[Anonymous]

Great!

🙂