Question about comparison operators

[Jorich919]

Can someone please tell me when to use -= for "not equal to" and when to use <> instead?  I keep getting this mixed up. Is there a cheat sheet for these types of syntax snafus?

Thanks!!

[Vegar]

Use -= in SET analysis when declaring fieldvalues to exclude

Sum({$<Year -= {'2019'}>}Amount)

For everything else you use <>

[prabhu0505 · Accepted solution]

-= Exclude a value or set of values from a particular field in set analysis

<> works in expressions, load script but cannot be used in set analysis 

[Jorich919]

Ah ha!! I think I'm getting this. 

So I would use <> in an IF statement??

[prabhu0505]

yes you can use it in if statement of expression and load statement

[Vegar]

Yes in an IF statement you would use IF.

Eg.

IF 1<>2 THEN
  LOAD 
    *,
    IF(Date<>today(), 'Not today', 'Today') as TodayFlag 
  FROM 
    DaTa;
END IF

[Jorich919]

Got it! Thanks to both of you!!