CF mathmatics

Question

Need a bit of assistance.  I have a client who manually creates a report t the end of each year that consists of poundage of every product per customer.  A customer may buy 50K lbs of different products each year.  Is there a way that I can add anywhere from 2 to 1000 different numbers together by outputting the data into a cfset tag or something else?

BKBK · Accepted Answer

SELECT *FROM purchaseordertableWHERE BuyerName = 'NFLLC' and Packstyle = '18/8oz. Bags'ORDER BY packstyleI want to add all returned values for Quantity.Following the query, use query-of-a-query: SELECT SUM(quantity) as totalQuantity FROM gcr

BKBK · Answer

Are the numbers coming from a column in a database table? If so, use the cfquery tag to construct a query that reads the values from the database. Then add the values in the query.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.