# Using an expression to AVG a tables column contents **URL:** \ **Category:** Ignition\ **Tags:** ignition81, perspective\ **Created:** [November 27, 2023, 6:21pm UTC](https://forum.inductiveautomation.com/t/using-an-expression-to-avg-a-tables-column-contents/82390 "2023-11-27T18:21:43Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Post date:** [November 27, 2023, 6:21pm UTC](https://forum.inductiveautomation.com/t/using-an-expression-to-avg-a-tables-column-contents/82390/1 "2023-11-27T18:21:43Z")
Is there a way for me to use an expression on a label to display the average of a tables column data, regardless of row count? My example, my table return this: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/0/d0a85aae9b125e5c3368f681d73b7f6697eae9d2.png) The table could several more rows beside the 3 listed here. I would like to take the column Avg\_Eff and then average it for an Overall\_avg., then display that value in a label. Thank you ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [November 27, 2023, 6:26pm UTC](https://forum.inductiveautomation.com/t/using-an-expression-to-avg-a-tables-column-contents/82390/2 "2023-11-27T18:26:26Z")
[Yes](https://docs.inductiveautomation.com/display/DOC81/mean). ---
**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Post date:** [November 27, 2023, 6:29pm UTC](https://forum.inductiveautomation.com/t/using-an-expression-to-avg-a-tables-column-contents/82390/3 "2023-11-27T18:29:48Z")
@pturmel Very pimp, THANKS! Much better than doing in SQL.