Rules of operation for contribution calculation

  • The formula bar displays the formula used to calculate the percent value. Alternatively, double-click the percent value to show the formula.
  • The contribution is calculated according to this formula:
    • % Contribution = Value for component/sum of database values for all components * 100
    • In the preceding example, although the value for Returns/Discounts is subtracted when evaluating the formula, the actual value stored in the database is positive. Therefore, the sum of all components in the map is 257,778 (242,327 in cell G1 + 0 in cell G5 + 15,451 in cell G9). Consequently, the contribution for Sales is 94% (242,327/257,778 * 100).
  • You can calculate both sensitivity and contribution in the same formula map. If variance data is included, these options are disabled.