SAP Knowledge Base Article - Public

2587169 - Cannot delete and / or expressions in Calculated Columns in ORD / Canvas Reports

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 HCM Suite:

  • Online Report Designer / Advanced Reporting

Cause

Working as designed / system limitation

Resolution

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.

You would 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.

If you feel the feature is important, we request you to submit an enhancement request for the same.
2090228 - How to submit enhancement requests for SAP SuccessFactors products
This will allow other customers to vote up and thereby express their interest on the same.
Our Product management teams review enhancement requests regularly and implement them if and when feasible.

Keywords

Calculated, Column, ORD, delete, expression, unbale, change, edit , KBA , LOD-SF-ANA-ORD , Online Report Designer , Product Enhancement

Product

SAP SuccessFactors HXM Suite all versions