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

Ignition
,
1

Good afternoon all! Can I sum the "Cost_In_Dollars" column into a single label? Here is my table

image
image1022×639 29.3 KB

Here is my named Query:

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
2

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

6 Likes
3

Thatll do it!

4

Something something floating points for currencies meme.

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

4 Likes
5

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

2 Likes