Skip to content

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.

  • 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.