Calculated Field with Logical Operator (AND)

[KausikKhanra]

Hi

Please find below a simple example, it’s working with single condition, but not working for multiple conditions with AND while trying to create a calculated field on Data Manager; it works fine with Analysis Tab though. 

What I observed is 'AND' is not recognized on Data Manager while it's recognized on Analysis. Why Logical operators (AND, OR, NOT) are not part of Data Manager?

Single Condition: IF(1>2, A, B) works fine

Multiple Conditions: IF(1>2 AND 2>3, A, B) throws error.

[hvfalcao]

same here... did you found any solution?

[JuMo]

UP ⬆️

Hello, same problem here with 'OR' operator

[Or]

As far as I know, this remains a limitation of the Data Manager. One has to either use the Data Load Editor, or use nested if() statements, e.g.

if(1>2,if(2<3,1,0),if(2<3,1,0))

[JuMo]

Thanks, I will go for that, but I am quite surprised that such basic operators are not available

[Or]

I never use Data Manager, so I never noticed until someone asked about it on Community. I'd suggest graduating to Data Load Editor as soon as you're comfortable doing so.

[marcus_sommer]

Beside the nested if-approach you could try to replace the logical operators with mathematical ones - means something like:

IF(1>2 * 2>3, A, B)

- Marcus

[JuMo]

Thanks, thats what I've done