You will sometimes need to insert the total value of a numbers column somewhere in your document. For example, you might want to generate invoices where you need to show the total amounts separately below the table:
In this case, the highlighted values are the sums of the columns Item Total, Tax, and Extended Total:
To pull these total values into the document, use this placeholder:
… and replace “COLUMN LABEL” with the name of the column. For example:
- <<column_sum:Item Total>> will show the total of the “Item Total” column, $9,600
- <<column_sum:Tax>> will show the total of the “Tax” column, $1,152
- <<column_sum:Extended Total>> will show the total of the “Extended Total” column, $10,752
Please sign in to leave a comment.