One field possibly equal to many 2

[gbobbie]

CR 9 and 2 Excel Spreadsheets

I'm trying to write a formula field that shows only those from table1.field1 if not equal to table2.field1, table2.field2 or table2.field3. I thought this would be relatively simple, but the formula isn't working correctly and is as follows:

If {table1.field1} <> [{table2.field1},{table2.field2},{table2.field3}] Then
{table1.field1} Else
""

Any help is appreciated!

THANK YOU!

 

[satinsilhouette]

I think you need to handle this in a case statement

select {table1.field1}

case <> {table2.field1};
{table1.field1}

case <> {table2.field2};
{table1.field1}

case <> {table2.field3};
{table1.field1}

it will handle it better otherwise I think a if then else would do the same if you are more comfortable.

Thanks so much!
satinsilhouette

 

[gbobbie]

Thank you so much. However, I'm getting an error on the <> operator.

 

[lbass]

Try:

not({table.field} in [{table2.field1},{table2.field2},{table2.field3}])

-LB