Insert column totals anywhere in a document

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:

<<column_sum:COLUMN LABEL>>

… 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

Leave a Reply