I am trying to resolve, I tried this <cfoutput>=SUM(C2:C11)</cfoutput> and, it works. But my table will grow as battery types are added. Any help?
1 person found this helpful
If tbl_Assembly_Production is a cold fusion query object, you can use either Q of Q
select sum (something) from etc
x = arraysum(queryname["fieldname"])
I'll give that a shot. I ran into something issues. Data Integrity!!!!!!!! No matter how hard you work at something, you will always find other ways to work harder at it......... To improve it no doubt.
You should do all of the sums and other summaries in an SQL query that references the appropriate table(s). If you can't do the job in a single SELECT statement (I'll bet you can...) then you can use "subqueries" in SQL.
Let the database server do all of the hard work for you and send you only the results you need. You don't want thousands or millions of records to "flow over the wire" just to be added-up.