Generating values based on column

[Arnab_Dutta]

Hello,

I am trying to do the following:
Data table A:
Name
Project
Start-Date
End-Date
AllocationHours
DailyHoursBurnRate

Data table B:
Month
AllocatedHours (Virtual)

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!

thanks.