I am trying to do the following:
Data table A:
Data table B:
I want to compute AllocatedHours as a total burndownvalue for each month which should be equal to SUM of [(No.of working days assigned in month)*DailyHoursBurnRate] .
I can compute the allocated working days for the month for each row in table A, but then cannot work out how to implement a calculation within a SELECT statement for matching rows.
Any suggestions would be appreciated!