# Can/How do I sum column rows into a label?

**URL:** <https://forum.inductiveautomation.com/t/can-how-do-i-sum-column-rows-into-a-label/72849>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [April 24, 2023, 8:59pm UTC](https://forum.inductiveautomation.com/t/can-how-do-i-sum-column-rows-into-a-label/72849 "2023-04-24T20:59:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\
**Post date:** [April 24, 2023, 8:59pm UTC](https://forum.inductiveautomation.com/t/can-how-do-i-sum-column-rows-into-a-label/72849/1 "2023-04-24T20:59:55Z")

</div>

Good afternoon all! Can I sum the "Cost\_In\_Dollars" column into a single label? Here is my table

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/0/909f7fab04136f133242c6d7c685fc6fc483a488.png)

Here is my named Query:

```auto
SELECT t_stamp,
	  [271_Valve_ON_Time_minutes],
	  ([271_Valve_ON_Time_minutes]* 0.02) AS Cost_In_Dollars
	   
FROM M18S_Extrusion_Wand_Usage 
WHERE t_stamp BETWEEN :start_Time AND :end_Time 

```

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [April 24, 2023, 9:02pm UTC](https://forum.inductiveautomation.com/t/can-how-do-i-sum-column-rows-into-a-label/72849/2 "2023-04-24T21:02:27Z")

</div>

I'd say a sum expression on the label would do it.  
[https://docs.inductiveautomation.com/display/DOC81/sum](https://docs.inductiveautomation.com/display/DOC81/sum)

---

<div class="post-metadata">

**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\
**Post date:** [April 24, 2023, 9:07pm UTC](https://forum.inductiveautomation.com/t/can-how-do-i-sum-column-rows-into-a-label/72849/3 "2023-04-24T21:07:08Z")

</div>

Thatll do it!

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 24, 2023, 9:13pm UTC](https://forum.inductiveautomation.com/t/can-how-do-i-sum-column-rows-into-a-label/72849/4 "2023-04-24T21:13:38Z")

</div>

Something something floating points for currencies [meme](https://www.imdb.com/title/tt0151804/).

(As long as it's just a casual informational thing, no harm done. But don't use floating point numbers for anything accounting-related).

---

<div class="post-metadata">

**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\
**Post date:** [April 24, 2023, 9:15pm UTC](https://forum.inductiveautomation.com/t/can-how-do-i-sum-column-rows-into-a-label/72849/5 "2023-04-24T21:15:02Z")

</div>

Yeah its just casual, nothing that would break our companies policies.