topic Re: Calculated Field with Logical Operator (AND) in App Development

Calculated Field with Logical Operator (AND)

KausikKhanra — Sat, 16 Nov 2024 20:27:34 GMT

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.

Re: Calculated Field with Logical Operator (AND)

hvfalcao — Fri, 27 Mar 2020 14:03:18 GMT

same here... did you found any solution?

Re: Calculated Field with Logical Operator (AND)

JuMo — Wed, 23 Mar 2022 13:08:03 GMT

UP ⬆️

Hello, same problem here with 'OR' operator

Re: Calculated Field with Logical Operator (AND)

Or — Wed, 23 Mar 2022 13:19:40 GMT

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))

Re: Calculated Field with Logical Operator (AND)

JuMo — Wed, 23 Mar 2022 13:24:59 GMT

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

Re: Calculated Field with Logical Operator (AND)

Or — Wed, 23 Mar 2022 13:41:55 GMT

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.

Re: Calculated Field with Logical Operator (AND)

marcus_sommer — Wed, 23 Mar 2022 16:03:09 GMT

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

Re: Calculated Field with Logical Operator (AND)

JuMo — Thu, 24 Mar 2022 09:05:06 GMT

Thanks, thats what I've done