Ratios and percentages
Set Divide By Measure on a trend to show one measure divided by another for each period. For example, profit %:
| Measure | Divide By Measure | |
|---|---|---|
| Source Table | Cust. Ledger Entry | Cust. Ledger Entry |
| Aggregation | Sum of Profit (LCY) | Sum of Sales (LCY) |
| Filter | Document Type=Invoice|Credit Memo |
the same |
With Show as % on (it’s set automatically), the ratio is multiplied by 100. Add the suffix % and 1 decimal place.
This is the same calculation as Business Central’s own sales statistics: total profit divided by total sales for the period, not an average of percentages.
Good to know
Section titled “Good to know”- Periods with nothing to divide by, such as days without sales, are left out, so the line stays meaningful.
- For percentages, the change against the previous period is shown in points, for example ▲ 1.3 pts.
- By Period: the Divide By measure’s table needs a date field with the same name as the trend’s Date Field, for example Posting Date.
- Snapshots: both measures are saved each day.
- Clicking a point opens the records of the main measure.