Set Analysis not equal to Syntax

[cliff_clayman]

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?

[cliff_clayman]

I think that is the issue.  How do I account for NULL values then?

[rupamjyotidas]

Maybe This.

=sum({($ -<Flag={'*'}>) Sales)

[rupamjyotidas]

Or define something for NULL in Script

If(Flag<>'X', Y) as Flag

and use Set Analysis in equation

[cliff_clayman]

That doesn't work.  If I cannot determine a way to do it within Set Analysis, I will just add something to the script that gives it a value when it is not 'x'.

[cliff_clayman]

That does not work, most likely because of the NULL values as well.

[Anonymous]

Hi Cliff, I prefer to do the exclusion in two steps to manage null values better:

=Sum(Amount)-Sum({$<[Flag]={'x'}>}[Amount])

Regards!!

[nagarjuna_kotha]

If want to get solution quickly, try to share sample data or else Qvw.

-Nagarjun

[Peter_Cammaert]

If the rows where Flag is a field have some sort of unique ID, you could try with an expression search. For example:

=Sum({<SalesOrderID = {"=Flag <> 'x'"}>} Amount)

[Anonymous]

Hi Cliff,

Can you try below expression. I just removed the quotes in the value.

=Sum({$<[Flag]-={x}>}[Amount])

Hope this time it should work.

[Anil_Babu_Samineni]

Perhaps this

=Sum({$<flag -= {'x'}>} amount)

I've written all lower letters

The better Sample Data. Why this is not working? Have you get any typo error from Expression

Load * Inline [

flag, amount

x, 10

y, 20

z, 30

];

For me this expression is working. Would you provide data which you expecting