Set Expression help

[#1]

Hello QV,

I have below expr in my chart.

sum({<Segment={'Group'}, Status = {'Cancelled'}>}[REV YTD])/1000000

Now my requirement is to exclude Cancelled Accounts, means Status is not equals to 'Cancelled'.

How to write the expr for the same.

Thanks,

Ananth

[martinpohl]

This variant

sum({<Segment={'Group'}, Status -= {'Cancelled'}>}[REV YTD])/1000000

gives you the result of all status excluded Cancelled, indepentend of what status is selected

and this

sum({<Segment={'Group'}, Status = {'*'}-{'Cancelled'}>}[REV YTD])/1000000

gives you the result of selected values in status, excluded Cancelled if selected

Regards

[#3]

In the image,

The same account is coming in both the chart. Why this is happening

[ashfaq_haseeb]

May be same account but with different revenue.

you need to look at your data.

Do some tests to validate the same.

Regards

ASHFAQ

[#5]

Thank you very much to all, I'm verifying my data.

[ashfaq_haseeb]

Can you close this thread by selecting appropriate answers.

Regards

ASHFAQ