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:

There are two scenarios associated with column sums:

# 1. Main item column sums

To insert the sum of the values of a main column (not subitems) 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 (see above example)**<<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

## Important considerations

<<column_sum:xxx>> placeholder work only with main items; it does not work with subitems.

# 2. Subitem column sums

To insert the sum of the values of a subitems column into the document, you need to create a summary column on the parent item:

1. Click on the three dots next to the subitem column name

2. Click on 'Show Summary on Parent Item'. This will create a new column on the board showing the sum of the subitem column that you selected.

3. Insert a <<column_firstrow:xxx>> placeholder anywhere in your template (where you should replace 'xxx' with the new column title.)

## Comments

0 comments

Please sign in to leave a comment.