3570190 - SAP BW Sign Reverse doesn't work in SAP Analytics Cloud Calculated Measures

• Sign Reverse does not work.
• SAP BW Query defined with a Calculated Measures with sign reverse, does not display as expected in a Story in SAP Analytics Cloud.

• SAP Analytics Cloud 2024.21.14

1. In an SAP BW Query, create a Calculated Measure based on multiple Measures
2. Set the Measure has "Reversed Sign" enabled within SAP BW.
3. In SAP Analytics Cloud, create a Story based on the SAP BW Query.
4. Observe the "Reverse Sign" effect is not inherited by the Calculated Measure.

• Sign reverse for calculations in SAP BW Query is not supported, and this is why it does not work.
• A Calculated Measure does not inherit the "Reverse Sign" effect.

• To achieve this behavior in a Story in SAP Analytics Cloud, use the Measure in the Calculated Measure calculation and multiply it with -1

• Calculation Editor (Specifics for SAP BW) | SAP Help Portal
• Create Calculated Dimensions in Tables | SAP Help Portal 

change sign reverse sign calculated measure wrong incorrect , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-DES , Story Design & Visualizations , Problem