Ok, so I have two tables:
SOW TABLE
SOW # | SOW Amount |
1 | $10,000 |
2 | $4,000 |
3 | $2,000 |
4 | $1,000 |
PROJECTS TABLE
PROJECT NAME | Project Price | SOW # |
Website Design | $5,000 | 1 |
Logo Design | $2,000 | 1 |
Icon Design | $500 | 2 |
Brochure | $3,000 | 2 |
Label Design | $1,500 | 3 |
I Left Join these two tables on SOW: SOW # = Projects: SOW #
The join results in this table:
SOW # | Project Name | SOW Amount | Project Price |
1 | Website Design | $10,000 | $5,000 |
1 | Logo Design | $10,000 | $2,000 |
2 | Icon Design | $4,000 | $500 |
2 | Brochure | $4,000 | $3,000 |
3 | Label Design | $2,000 | $1,500 |
4 | - | $1,000 | - |
I want to calculate how much budget has been used for each SOW. Seems it should be dead simple but can't figure it out...
LinkedIn
Twitter
