Calculated field with 'if' formula and 'AND' operator referring to different data fields

[Dik]

Hi guys,

A newbie question (I guess)... I try to implement one calculated field in my data table with the following ‘if’ formula:

If([A]<>'Content01' AND [B]<>'Content02','Output01',If([A]<>'Content01' AND [B]='Content02','Output02','Output03'))

But unfortunately I get always the error: “Missing right parenthesis”. As additional information, I can say the fields [A] and [B] are text fields as well as all outputs fields. Isn’t it possible to use AND within an ‘if’ formula in calculated fields?

A helping hand would be great. Thank you!

[Kashyap_R]

Hi

Can u attach sample qvf so I can try it out

Thanks

[JordyWegman · Accepted solution]

Hi Dik,

There are no newbie questions.. but mentioning this seems that you haven't used it a lot, are you using the Data Manager? Because it's not possible to add AND statements in a newly created field.

Jordy

Climber

[Dik]

Hi guys,

Yes, I'm trying to create this new calculated field within the data manager. What a pity that it isn't possible to work with AND there. But nevertheless, thank you for your feedback. At least I know I don't have to keep trying it that way. 

BR, Dik

[JordyWegman]

Yes it's a shame, seems like an easy option so I don't know why it isn't added.

Jordy

Climber