SAP Knowledge Base Article - Public

3235609 - Custom variance measures calculation using the Add Variance feature in SAP Analytics Cloud (SAC)

Symptom

  • When creating Variance calculation in a chart using the "Add Variance" feature in SAP Analytics Cloud (SAC) it will use the format of (A-B)/B*100.
  • Although as can be seen in following blog post it's possible to create custom variance calculation with the use of restricted measures, it's not possible using the "Add Variance" feature.

Environment

  • SAP Analytics Cloud (Enterprise) 2021.8.17

Reproducing the Issue

  1. Select desired chart to create custom variance calculation.
  2. Use the 3 dots on the right side of "Chart Structure" to "Add Variance".
  3. See that it's not possible to customize the calculation formula.

Cause

  • Currently it's not possible to customize the Variance calculation in SAC when using the "Add Variance" feature.
  • It's only possible by creating restricted measures.

Resolution

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAC custom variance calculation, variance, variances, add variance, add variances , restricted measure variance calculation, custom variance, custom variance calculation, custom variance analysis, variance analysis , KBA , LOD-ANA-DES , Story Design & Visualizations , Product Enhancement

Product

SAP Analytics Cloud 1.0