Feature Request: Auto-include formula total in BOE text
Summary:
Automatically insert and keep the calculated total in the BOE text so that when underlying values or formulas change, the displayed total in the BOE updates accordingly without manual editing.
Problem Statement:
Today, users must manually type the total value into the BOE text. When any part of the calculation changes, the total displayed in the BOE text does not update, forcing users to re-calculate and re-enter the value. This manual step is error-prone, time-consuming, and can result in BOE documents showing outdated or incorrect totals.
Proposed Solution:
Enable BOE text fields to reference and display the current total from the associated calculation or formula.
When the underlying data or formula changes, automatically refresh the total shown in the BOE text so it always reflects the latest value.
Provide a clear way for users to insert a “total” token or placeholder into BOE text (e.g., via a field picker or dynamic variable) that binds to the relevant calculation.
Ensure formatting options (e.g., decimal places, currency, units) are configurable so the total appears in the appropriate format for the BOE.
Handle cases where the calculation is missing or invalid by showing a clear indicator or fallback text instead of a stale or incorrect total.
Benefits:
Eliminates manual re-entry of totals, reducing the risk of human error.
Keeps BOE text synchronized with underlying calculations, improving accuracy and trust.
Saves time for users preparing or updating BOE documents, especially when values change frequently.
Improves consistency of presentation by enforcing a standard, configurable format for totals.