SAP Knowledge Base Article - Public

3244127 - ELSEIF condition in Advanced Formula is not evaluated

Symptom

Advanced formula data action with IF, ELSEIF condition no longer works

The first IF condition is evaluated, but the ELSEIF is not

If the two conditions are swapped the new IF condition is evaluated and the original IF is not, so the issue is not the condition itself but the fact that it is called by ELSEIF

Issue does not occur for all ELSEIF conditions, only those that contain different dimensionality from the IF condition

Environment

SAP Analytics Cloud version 2022.15.8 (2022 QRC3 release)

Reproducing the Issue

  1. Create an advanced formula with an IF and ELSEIF condition that are both valid
  2. Execute the data action via either a data action trigger or calendar task
  3. The IF condition will be executed but the ELSEIF will not

Cause

Issue is the result of performance enhancement on SAC QRC3

The issue occurs if the following condition is met:

  • IF / ELSEIF or ELSE / ENDIF
  • Cell value filters in IF or ELSEIF Condition
    • IF RESULTLOOKUP() > RESULTLOOKUP()
  • Different dimensionality
    • IF RESULTLOOKUP([d/Region]) > RESULTLOOKUP()
    • IF RESULTLOOKUP([d/Account) > RESULTLOOKUP([d/Region])

Resolution

This issue will be fixed in an upcoming patch release which is scheduled for the week-end of September 24-25, 2022.

As a temporary workaround you can break the IF / ELSEIF logic flow into multiple IF / ENDIF statements to work around the issue.

Keywords

KBA , LOD-ANA-PL-AF , Advanced Formulas , Problem

Product

SAP Analytics Cloud all versions