Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Complicated Sum
That worked. Instead of doing a view though, I dropped that select in as a sub-query. Its kinda nasty, and I'll try and clean it up, but it works. -
Complicated Sum
The data I get back when I run SELECT program, df_date, SUM(direct) AS acwp FROM opp.tphase WHERE class = 'AC' AND program = 'E01043' GROUP BY program, df_date is: Program DF_Date ACWP E01043 10/30/2005 1204.55 E01043 11/27/2005 711.08 E01043 12/25/2005... -
Complicated Sum
Also, this is going to be part of a coldfusion page, which is why I would like to do it with one query. -
Complicated Sum
No, it won't. It is possible for projects (users) to fix past data. While this has caused much consternation for those trying to build reports it is allowed to happen. At any one run of the query it would only be getting data for one Program. So there will probably be another part of the... -
Complicated Sum
The table I'm working in has 4 columns that I am worried about: Program, direct, df_date and class. What I need to do is a sum of direct with a group_by program and df_date where class = 'AC'. Simple enough. However, the values I need to pull for the sum need to be a sum of all items on that...
