# Math Extensions for Ignition **URL:** \ **Category:** General Discussion\ **Created:** [July 18, 2011, 12:42pm UTC](https://forum.inductiveautomation.com/t/math-extensions-for-ignition/3106 "2011-07-18T12:42:07Z")\ **Posts on this page:** 1\ **Showing post:** 20
**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\ **Post date:** [January 25, 2023, 1:59pm UTC](https://forum.inductiveautomation.com/t/math-extensions-for-ignition/3106/20 "2023-01-25T13:59:45Z")
> [@kavya\_shree](#): > > do total of column values in a power Table. I recently posted a couple of examples of this here: > [@Display sum of a column at the end of the table](https://forum.inductiveautomation.com/t/display-sum-of-a-column-at-the-end-of-the-table/68717/6): > > There are at least two approaches that would work here. You could write a second select statement that automatically generates the sums, and then append it to the last row of your existing query with a union. In this way, the data comes directly from the query with no intermediary scripting required. The query would look something like this: > > > **Sample Query** > > > > SELECT EquipmentName as 'Machine No', ShiftID as 'Shift', TIME\_FORMAT(SEC\_TO\_TIME( SUM(CASE WHEN StateChangeFrom = … --- _[View the full topic](https://forum.inductiveautomation.com/t/math-extensions-for-ignition/3106)._