Configurator Formulas for Microsoft Dynamics 365 Business Central
Configuration logic often starts life in a spreadsheet, full of formulas for lengths, allowances, and conditions. A configurator that cannot express the same math forces teams to simplify the product or keep the spreadsheet. Product Configurator uses an Excel-like formula language with a documented function library, in component quantities, routing run times, and rules.
The same expression evaluator is shared across several Insight Works apps.
How Configurator formulas works in Product Configurator
- A product manager or engineer identifies the calculations the product needs, often from an existing spreadsheet.
- Each calculation is written as a formula on the choice, operation, or rule that needs it.
- Lookup tables are set up where values come from data.
- The configuration is tested with representative values.
- Formulas evaluate as salespeople configure, and the results reach the item's bill of materials (BOM), routing, and price.
Key capabilities
Familiar formulas
Formulas reference option values by code, such as length+2 or max(3; length/2), and most calculations you would do in Excel can be done in the configurator.
A documented function library
Functions cover trigonometry, rounding, minimum and maximum, powers, sequences, conditional logic, and divide-by-zero protection.
Wherever numbers are needed
The same language is used in calculated quantities, routing run times, and rule conditions and values.
Lookups
Lookup functions can read values from generic lookup tables or existing Business Central tables, so a formula can take a value from data instead of hard-coding it.
Parent values
In sub-configurations, formulas can reach a parent configuration's values with a Parent prefix.
Custom functions
Developers can add custom expression functions through an extension, for calculations specific to your products.
See Configurator formulas on screen
Real screens from Product Configurator, shown with demo data.
Details that matter on the floor
Spreadsheet logic carries over
Teams moving from a spreadsheet configurator can usually express the same calculations, which keeps product rules intact through the move.
One language to learn
Quantities, run times, and rules use the same formula syntax, so a product manager learns it once.
Who uses Configurator formulas
Product managers
Write the calculations that drive quantities and rules.
Manufacturing engineers
Express material allowances and run time logic as formulas.
Implementation consultants
Convert spreadsheet logic into configurator formulas.
Questions about Configurator formulas
Does Product Configurator support Excel-style formulas?
Yes. It uses an Excel-like formula language with a documented function library, so most calculations you would do in Excel can be done in the configurator.
Where can formulas be used?
In component quantity formulas, routing run time calculations, and rule conditions and values.
Can formulas read data from Business Central?
Yes. Lookup functions can read values from generic lookup tables or existing Business Central tables.
Can we add our own functions?
Yes. Custom expression functions can be added through an extension. See extensibility.
Related Product Configurator features
All Product Configurator features →Part of Product Configurator
Simplify creating BOMs and routing to make quote and order generation more efficient.
Have a question about Configurator formulas?
Send us a note and the Product Configurator team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
