3438474 - Lookup Formula not working in combination with multiplication

LOOKUP formula is not working on hierarchy when using a multiplication but aggregating the sum of the values instead

Lookup & Reference Formulars are not working in combination with operator “multiplication” (*)

The results shows the SUM of nodes instead of Multiplication

The separate LOOKUP formula works correctly, it only incorrect in combination with Multiply

SAP Analytics Cloud

Create a Calculation with Multiplication based on Hierarchy data

The issue resolved in coming QRC release. See 2888562 - Intelligent Enterprise Suite: Harmonized release calendar for SAP Cloud products 

Solution to be released was tested and approved by Development.

Currently there is a workaround:

split the Lookup / Restrict formula in to a separate calculations.

e.g.

Replace
Formula A -> 4 * LOOKUP(...)

with

Formula A -> 4 * [B]

Formula B -> LOOKUP(...)

KBA , LOD-ANA-ML-CAL , Calculation Management , Problem