You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Forms calculation - IF(%(field) != 'x') - How do I get the "Does Not Equal" to work?

posted on January 18

This should be simple, but I just can't seem to get it to work.  Using calculated fields in Forms, what expression do I use for "does not equal?"
 

I've tried '!=' and '<>' but get a field calculation error.

0 0
replied on January 18

Hey Sean,

You should be able to use <> you will need to wrap your "x" in double quotes. I just tested the following simple expression that sets a field equal to either 1 or 0 based on whether or not another field IS NOT EQUAL to 1. The formula is added to Field1 and works as follows:

If Expression1 is not equal to "1", then our field is 0, else our field is 1.

=IF(Expression1<>"1",0,1)

 

2 0
replied on January 18

Double quotes, that's what was messing me up!  Thanks!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.