Rules of operation for sensitivity calculation

  • The decimal values displayed in the nodes are rounded values. To view the exact decimal value, click on the rounded value in the node. The full decimal value displays in the formula bar. Alternatively, double-click the rounded value to show the full decimal value in the node.
  • The sensitivity is calculated according to this formula:
    • Sensitivity = (% change in primary data value)/(10% change in component value)
    • For example, if Total Sales = Sales - Returns/Discounts, then the sensitivity for Returns/Discounts is calculated by the percent change in the Total Sales value when Returns/Discounts is increased by 10%.
    • In the preceding example, the sensitivity for Returns/Discounts is rounded to -.1. The actual decimal value is -.062063952084544. Therefore, if the value for Returns/Discounts is increased by 10%, then Total Sales should decrease by approximately .62%, the actual decrease may vary slightly from the projected percentage.
  • Sensitivity values are calculated for all leaf nodes.
  • The sensitivity values show as negative values in the map nodes when an increase in that component would cause a decrease in the calculated results.
  • When sensitivity is calculated for a component, including parent nodes in the collapsed state, the label for the component is displayed in the sensitivity table, or list.
  • The sensitivity table is sorted by order of impact each component has on the calculated results. It does not reflect negative values. The table can also be filtered by clicking in the table.