Are they actually numbers or do you have them stored as dollar values? ($1,500.00 or 1500)
Show us a table structure. Show us the code to output them. In one of those 2 places, you add them together. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Toby King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 17, 2007 8:04 AM To: CF-Talk Subject: column totals I have a program which produces output as follows: Projects Jul 2006 Aug Sept Total Project 1 - revenue: $1,500.00 500 500 Project 2 - revenue: $1,000.00 Project 3 - revenue: $ 500.00 Total Revenues: $3,000.00 Its calculating the column totals correctly, (only shown July but it shows Jul-June) - with a Total column at the end - but I am struggling a little on the best approach so as to calculate the row totals. I am thinking of creating an array, and then each time I get a new column I add the value in question to the array (I know that there will always be 12 columns). I'm stumped though on determining the number of rows ??? there could be 3 or there could be 23. Basically what has been done previously by someone is that they created a table for the name of the projects on the left and then a new table for each month that is outputted. The number of rows to be produced for a month is determined by the number of projects underway. This table is looped obver so as to produce the correct number of rows. I think an array(s) is one approach to take but am struggling with this one a little - look forward to suggestions. How would you recommend handling this. Is it as simple as just setting up an array or would you suggest a better approach? Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
