Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Scott
Posting Yak Master
145 Posts |
 Posted - 2001-10-12 : 02:40:28
|
| I have a project budget and <=6 milestones which consist of a description, date of completion and the total % of the budget that will be used up at completion of that milestone.eg Budget = $10 000Descript | Date | Percent------------------------------Mile1 1 Jan 5Mile2 2 Feb 24Mile3 26 Feb 48Mile4 1 Apr 67Mile5 23 Apr 85Mile6 5 May 100From this I need to generate a planned monthly expenditure, per project or for all projects grouped together.Anyone with any ideas.Thanks |
|
|
|
|
|
Math & Group By