Ratios

Allows the user to specify the value data shown in the grid:

• Margin %
  Margin divided by Revenue x 100.
• Cost %
  Cost of Goods Sold divided by Revenue x 100.
• Revenue per Unit
  Total Revenue divided by Units.
• Margin per Unit
  Total Margin divided by Units.
• Revenue Percentage of Total
  Revenue value as a percentage of Column
• Margin Percentage of Total
  Margin value as a percentage of Column
• Units Percentage of Total
  Units as a percentage of Column

  

  If, for any of these calculations, the denominator (either Revenue or Units) in the cell is zero, Salesmatrix will display zero, even though there may be a positive value in the numerator.

  For all ratios that are "Percentage of total" the traffic lights are calculated across the rows, instead of down the columns.