This article how to sum up a field and place the total in the footer of a table.
Imagine you are creating a quote with multiple products (line items) for your customer, and need to list the total of all products.
Step-by-Step instructions:
Start with opening your DocumentsCorePack TemplateDesigner and navigate to the ❶ table, which should show the total in the footer.
❷ Now copy the field that should be summed up into the ❸ footer (you may need to add a footer row via the Edit table options on the mscrm-addons.com ribbon).
After you have copied the field in the footer, navigate to the WORD-ribbon and select “Mark as Sum-Field” in the “Grouping”-area. When you now merge your document, the total of all listed products should be displayed. You can format the field (e.g. currency format) using the Field properties option in the mscrm-addons.com ribbon.
Please note: Make sure that the cursor position is in the sum field!
Now enjoy the result:
See also:
- Computed fields: The Computed Field property allows you to evaluate calculations of data from Dynamics 365.