F() with 'AND' argument not working

[maria871995]

Hello,

I am creating a new field in a table. I need to use two conditionals, but it returns error.

The code is the following:

IF((Match([PCO_OUTBOUNDLOG.QCODE], 6, 80, 81, 82, 83, 85, 90, 91, 92, 93, 94, 95, 96)) OR       ((Match([PCO_OUTBOUNDLOG.QCODE], 90, 91)) AND (TALKTIME < 50)), 'NO', 'SI')

I attach a photo.

Why doesn't it recognize the "and" and "or" functions?

Thanks in advance.

[BrunPierre]

Put the match values in quotation marks/single quotes.

IF((Match([PCO_OUTBOUNDLOG.QCODE], '6', '80', ...

[Or]

For reasons unknown, Data Manager does not support AND/OR statements. You would have to either re-state the condition using nested If() statements, or switch to using the Script Load Editor.