Calculating S% Billiable In Report

[deintinis]

I have a projection Report with the following fields:
Month
Year
Employee Name
Proposed Hours
Fees
Rate
% Billable

The Fees is a simple calculation of Proposed Hours times Rate. I am having a problem figuring out the best way to calculate the % Billable. The % Billable is the Proposed Hours Divided by the Total Possible Monthly Work Hours. I have a seperate table with the total Work Hours each month in which I created a relationship to a field in my main table of the same name. When I inserted this field into the report, before I even tried to do the calculation, the field only shows a 1 when I preview the report.

I would like this field to dispay the number of hours in the Month that is displayed in the report (which is grouped by Month). I would than need this total divided by the Proposed Hours to get my percentage billable.

Any help would be appreicated, I am starting to pull out my hair trying to figure out the easiest way to do this.

Thanks