Can I sum a columns value in a table with the reporting module

[Neil_Carty]

I have a report that is using a SQL query and a nested query to populate a table. Is there a way to sum a columns value of the table in the Reporting Module? I know you can @value*5@ but that is for each value returned for that column in the query. Was hoping to possibly use something like @SUM(value)@ in the footer of the table to show a columns total value. Not that easy i guess. Any suggestions?

[lrose]

Yes. Use the Summary Row in conjunction with the Calculation Keys

Manual page for calculation keys:
https://docs.inductiveautomation.com/display/DOC81/Data+Keys#DataKeys-ShowCalculationsProperty

Manual page showing an example:
https://docs.inductiveautomation.com/display/DOC81/Table+Rows

IU Video on Table Rows:

Table Rows Video at Inductive University

[josborn]

This is the first time ive seen the keychain docs, looks really useful.

Report table sum of rows (based on page)

You can definitely get the number of rows displayed so far with @Running.count@, but I don’t see a way to do the number of rows just on that page, ignoring previous pages. Maybe if you get creative with assignments? In the key browser with “Show Calculations” checked we only give you the most common keychain calculations. You can get the full range of possibilities and examples by going to the keychain docs.

Something like this in a summary row:
@total.value@

[Neil_Carty]

Thank you very much for the help!!! That worked. I didnt know there were so many options.

[Neil_Carty]

Another question on the reporting module. Can you perform date arithmetic in the reporting module? For instance i have one column that has an entry date and time and another column with an exit date and time. Could i populate a third row showing the difference of these two time stamps? I would do it in the sql query but the table format is not allowing me to do this.