Adding advanced features

Each formula map can optionally include these advanced features:

  • Variance data enables you to break down two formula values (such as Quarter 1 and Quarter 2) at the same time and show the variance percent at each component level.
  • Sensitivity calculation enables you to show a decimal value for each MPCData formula to represent how sensitive the calculated results are to changes in that leaf value.
  • Contribution calculation enables you to show a percent value for each formula component to represent its portion of the sum of its sibling components.