Logical operators

[bens]

I'm trying to get a script with a logical operator to work.

If i run the script without the "or" it works fine but when i use the or in the calculation it doesn't work.

What i want it to do is when customernumber is not what i define it shall exit the script else run the script.

i have attached an examble file.

test.fp7.zip

[Inky Phil]

Hi Ben

have a look at the attached see if it works for you

Phil

new_test.zip

[bens]

If i run that script under Record 1 (customernumber 2020120) it halt the script, it shall show test 2.

Thats what i want it to do.

[comment]

Your condition needs to be:

test::Customernumber ≠ 2020120 and test::Customernumber ≠ 2020121 and test::Customernumber ≠ 2020122

or, if you like:

IsEmpty ( FilterValues ( test::Customernumber ; "2020120¶2020121¶2020122" )

It would be better to have a field that describes some attribute of customer, instead of hard-coding data into a script.