How to Display the Sum of Two Fields in a Word Printable in Creatio?
11:41 Jul 02, 2025
Hello, I’m working with Creatio and I need help clarifying a question regarding printables.
I have a printable that uses two fields from the Orders object: Total (added in "Report setup data") and Tax Amount (added in "Report setup table").
Inside the Word template, I need to display the sum of these two fields.
Is it possible to calculate and display this sum directly in the Word printable? If so, how can I do that?
Like
1 comments
19:04 Jul 02, 2025
Basically, two choices that I can think of.
- Option 1: Create a macro. The macro would need the Id of the record passed in and you'd do an ESQ to read the two columns and return the result. See https://customerfx.com/article/creating-custom-macros-to-format-values-in-word-printables-for-creatio-formerly-bpmonline/
- Option 2: Use a database view. The view would have a lookup back to the main record (Order) and provide a column summing the two values. In the report, you could add this as an aggregate sum (which would be summing just the one record for the order). This approach could use the same view for any other calculations or values needed. See https://customerfx.com/article/using-database-views-in-creatio/
Ryan
Show all comments