Skip to content

Measures

A measure turns any Business Central data into a number your team cares about: overdue invoices, open orders, stock on order, sales this month. Define it once and every Dynamic product can use it, so the same Overdue invoices measure can be a role centre tile, an email alert and a trend chart, all from one place.

Search Dynamic Measures to see them all. You can also create one straight from a product’s setup using New Measure.

Field What it does
Code, Description How the measure is identified. Every product links to the measure by its code.
Source Table Any table in Business Central, including tables from other extensions, for example 21 Cust. Ledger Entry or 36 Sales Header.
Aggregation Type Count the records, or Sum, Average, Min or Max a field.
Aggregation Field The number field to add up, for example Remaining Amt. (LCY). Normal fields and FlowFields are both supported.
Filter Expression Which records to include, for example Open=Yes;Due Date=..{TODAY-1D}. See Filters and tokens.
Measure Type Standard or Per Record (see below).
Record Table Per Record measures only: the table of the record being viewed, for example 18 Customer.
Drilldown Page The page that opens when someone clicks the value. Leave it blank to use the table’s normal list page.
Enabled Switch a measure off to pause it everywhere at once.

Use Preview Value to check the result and Show Records to see the records behind it. Show Field Names lists the fields of the Source Table, to help write the filter.

Standard Per Record
Value One value, or one per user if the filter uses a user token Worked out for the record on screen
Example Overdue customer entries; my open sales orders Open orders for this customer on the customer card
Filter tokens Dates and users Dates, users and {Rec.Field}
Calculated In the background, then cached Live, every time, never cached
Used by Cues, FactBoxes, Alerts (total rules), Notifications, Trends FactBoxes, Notifications (on pages), Alerts (record rules)

To make a Per Record measure, set its Record Table, then use {Rec.FieldName} tokens in the filter to refer to the record on screen:

Document Type=Order;Sell-to Customer No.={Rec.No.}

With Record Table 18 Customer, this counts the open sales orders for whichever customer is being viewed. Show Record Table Fields lists the field names you can use. Preview Value and Show Records use the first record in the Record Table.

Measures in use are protected: their type and Record Table stay fixed while a product relies on them, so nothing breaks unexpectedly.

  • Count, Sum and Average run as a single database query, so they stay quick even on large ledgers.
  • Min, Max and FlowField totals read only the one field they need, and work best on a focused set of records, such as open entries or this month.
  • Role centre values are worked out in the background and cached, so role centres open quickly however many tiles you add.
  • Clear feedback, no broken pages. If a measure can’t be worked out, for example after a filter is mistyped, tiles show a neutral value instead of an error, and Preview Value and Dynamic Measure Cache tell you exactly why.
  • Protected while in use. A measure that a tile, rule, notification or trend relies on can’t be deleted by accident.