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.