2587169 - Calculated Column Designer cannot delete and/or expressions

SAP Knowledge Base Article - Public

2587169 - Calculated Column Designer cannot delete and/or expressions

Symptom

If a calculated column has an if-then statement like "if A and B then C" or "if A or B then C", the and/or operator cannot be removed.

Environment

SAP SuccessFactors Online Report Designer / Advanced Reporting

Cause

The delete function does not apply to and/or because the operators are not objects in the editor, like fields or tokens.  If you try to drag them to the TRASH icon, that line and everything below it in the query will be deleted.

Resolution

You may need to start the query over, or else use the TRASH icon on the expression and then rebuild everything below that point.  The quickest workaround is to substitute for the contents of the expression.

- If you want to remove part of an 'and' expression, substitute "1 == 1" or another certain equality.

- If you want to remove part of an 'or' expression, substitute a duplicate of one of the other conditions.

Keywords

KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors Workforce Analytics all versions