Set Analysis

[akpofureenughwu]

Compliments of the season,

I have set of data in the form

S/N	Company	Amount
1	Sam	2000
2	Luke	1000
3	Jack	1200

Using the set analysis,

To calculate amount for sam company

Sum({$<Company = {'Sam'}>}[Amount])  === correct

I want to calculate all company but sam..

Sum({$<Company <> {'Sam'}>}[Amount])  === I got incorrect expression

I don't want to use

Sum({$<Company = {'Jack', 'Luke'}>}[Amount])  because in the real data.. I have millions of companies

Regards

[sunny_talwar · Accepted solution]

Try this

Sum({$<Company -= {'Sam'}>}[Amount])

or this

Sum({$<Company = e({<Company = {'Sam'}>}Company)>}[Amount])

[Chanty4u]

Read this as well

Excluding values in Set Analysis

[akpofureenughwu]

Thank you Sunny for your prompt response as always. Thank you for your contribution in 2017.

And to all the leading contributors in this community, I salute you.

Regards