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.