Syntax for not equal to / different from

[guyvermeiren]

Hello,

I want to use a formula where I have as result all values except one. I found that the syntax for different from is " -=".

I tried the next :

=if(Opportunity.Status-='On Hold',null(),Opportunity.Status) but this gives me " error in expression.

What's wrong ??

Thanks,

Guy

[#2 · Accepted solution]

This syntax is for Set analysis.

For the if statement it is:

=if(Opportunity.Status<>'On Hold',null(),Opportunity.Status)

Rgds,

Sébastien

[guyvermeiren]

Sébastien,

Thanks, this works.

Kind regards,

Guy