Not equal not working?

[#1]

The following expression works great:

if((Color= 'Red') OR (Color = 'Green') OR (Color = 'Green'),Color)

And I found somewhere that -= is NOT EQUAL.  However, the next code gives me an error:

if((Color -= 'Yellow') AND (Color -= 'Purple') AND (Color -= 'Orange'),Color)

The error is ") Expected"

[robert_mika · Accepted solution]

Try:

if(Color <> 'Yellow' AND Color <> 'Purple' AND Color <> 'Orange',Color)

You do not need all the brackets

[Anonymous]

not equal  -= this syntax has implication only inside set analysis modifiers

Sum({<Color -={'Yellow' , 'Purple','Orange'}>}quantity)

here you can not use <> as not equal symbol

[jagan]

Hi,

You can also try Match() for this

=If(Not Match(Color, 'Yellow', 'Purple', 'Orange'), Color)

Regards,

jagan.

[nagarjuna_kotha]

Hi

Instead of that u can also use " <> ".

Regards,

Nagarjuna