=TABLESUM

The TABLESUM Function adds all the values from a specified column in a specified table.

Syntax

=TABLESUM(FieldID; TableID; TableQuery)

• FieldID**:** The ID of the column you will be adding

• TableID: The ID of the process table you’ll be pulling from

• TableQuery: The search query you want to apply to the function.

For functions such as TABLESUM and others, you have to know where to find each ID in the ProcessPlan URL. To find the IDs for table, field, and query:

1. Click on Reports > Process Tables > The specific process table you wish to inquire

2. Look at the URL, the TABLE ID can be found here:

https://ui.processplan.com/app/process/template/123456789012345678/table

The long number after /template/ is what you will use for TABLE ID

3. Click on the field that you wish to perform the SUM (must be a numeric field)

• Clicking the field will update the URL and give you the FIELD ID

• https://ui.processplan.com/app/process/template/123456789012345678/table?sort=**tf\_id\_234567890123456789**\_if\_text\[asc\] (Make sure to grab the tf_id_ text)

• The tf_id_ token after ?sort= is what you will use for FIELD ID

4. Finally, you can add a filter query. Click the Toggle Filter Row Icon on the top right then specify the filters, if any, that you wish to add to your TABLESUM

• Adding a filter will update the URL and give you the TABLE QUERY

• https://ui.processplan.com/app/process/template/123456789012345678/table?sort=tf\_id\_234567890123456789\_if\_text\[asc\]&filter=**ih\_progress\_percentage\[ct\]75**

• The text after &filter= is what you will use for TABLE QUERY.

Your final formula should look like the one below:

=TABLESUM(tf_id_234567890123456789_if_text; 123456789012345678; ih_progress_percentage[ct]75)