not equal in expression

[#1]

I need to create a where condition in an expression: shiow "STATO" when it is different to "ANNULLATO"

only({<[STATO]<>{'ANNULLATO'}>}STATO)

This expression not accept '<>'

Someone can help me?

[nilesh_gangurde]

Use this Expression:

only({<[STATO] -={'ANNULLATO'}>}STATO)

Regards

Nilesh Gangurde

[rajni_batra · Accepted solution]

only({<[STATO]-={'ANNULLATO'}>}STATO)

or

only({<[STATO]={'*'}-{'ANNULLATO'}>}STATO)

[uttamdwibedy]

Hi, here is another one:-

if(match([STATO],'ANNULLATO')=0)

[#5]

This works .... Thanks!

only({<[STATO]={'*'}-{'ANNULLATO'}>}STATO)

[#6]

And if i want replace "STATO" with an operation as: CASH-COSTS how can i do?

If I write

only({<[CASH-COSTS]={'7'}>}STATO)

I receive error for CASH-COST

[rajni_batra]

ur expression is perfect just check if making any spelling mistake or any kind of mistake in field name

[#8]

no mistake...it not accept the subtraction CASH - COSTS

[rajni_batra]

oh is this the subtrcation?? i thought this a field name...

i dont think this kind of subraction gonna work in set