Page background
Support item image

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.