Margin
Description
Difference between the cost price and the selling price of a product divided by the selling price to return a decimal value that should then be analyzed as a percent.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| Input 1 | Column or Literal | ✔ |
| Input 2 | Column or Literal | ✔ |
Remarks
Default output is a decimal value, but you can utilize Custom Numeric Formatting to adjust the format to be percent.
Example
- Equation: Gross Margin = (Revenue - Cost of Goods Sold) / Revenue
- Input: Revenue ($25,000), Cost of Goods Sold ($12,500)
- Quick Calculations > Math > Margin
- Output: 1.70
- Reasoning: Gross Margin = ($25,000 - $12,500) / $25,000 = 0.5 > 50%
- Adjust the format of the output to percent using the Custom Numeric Format option