Not equal to

[Anonymous]

Hi,

I need to see the all values of Summary_Status except Cancelled and Rejected.

Please help me to understand why this line of code doesn't work for me:

=if(Summary_Status <> 'Cancelled' or Summary_Status <> 'Rejected', Summary_Status)

[swuehl]

As you said ... except Cancelled and Rejected

=if(Summary_Status <> 'Cancelled' and Summary_Status <> 'Rejected', Summary_Status)

[PrashantSangle]

try,

count({<Summary_Status-={'Cancelled','Rejected'}>}Summary_Status)

Regards,

[ahmar811]

instant of your if expression used below expression

=if(wildmatch(Summary_Status,'*Cancelled*','*Rejected*')=0, Summary_Status)

Because sometime space remains with your string value so, first you have to trim your sting or remove space like below:

=if(trim(Summary_Status) <> 'Cancelled' or Trim(Summary_Status)<> 'Rejected', Summary_Status)

I hope this will help you.

Regards

Ahmar

[balabhaskarqlik]

try this:

If(Not(Match(Summary_Status,'Cancelled','Rejected')),Summary_Status)

[balabhaskarqlik]

=sum({$<Summary_Status-={'Cancelled','Rejected'}>}Sales)

=sum({$<Summary_Status-={'Cancelled','Rejected'}>}Field)

[balabhaskarqlik]

Check this:

Excluding values in Set Analysis

[Anonymous]

=if(Not wildmatch(Summary_Status,'Cancelled','Rejected'), Summary_Status)

[Anonymous · Accepted solution]

=if(Not wildmatch(Summary_Status,'Cancelled','Rejected'), Summary_Status)

[kmmreddy001]

Not equal to operator is not working as expected . Any help?

$value <>'26' AND $value <>'32'