Error using not equal in set analysis

[#1]

I am getting an error using the following set analysis:

=round(sum({<[Disti LOB]-={39},[CTA Duplicate]={'No'}>}$(vExtEffCommPrice))/1000)

The red squiggly line shows up on the left brace right before the 3.

Any suggestions?

I just want all records where Disti LOB <> 39

[swuehl]

The syntax checker in the expression editor isn't perfect. Marking operators like -= as error is a known bug.

Does the editor states 'Expression ok'? Does the expression return a value?

[#3]

no i get error in calculation

[nagaiank]

Is [Disti LOB] a field?

If that field contains text values, you may use [Disti LOB] -= {"39"}

Also check if the variable vExtEffCommPrice has a valid expression.

[MK_QSL]

=round(sum({<[Disti LOB]={*'}-{'39'},[CTA Duplicate]={'No'}>}$(vExtEffCommPrice))/1000)