Group By Month - Calculation

[b71]

Hi

I have a report filtered by individual showing a start date and end date for a task and also how many days they are spending on various sub tasks surrounding this.

The days spent on the main tasks and sub tasks are totalled in "group by month" view in the report to show how many days the individual is currently working per month.

In addition I have a table where the individuals "available days per month" are inputted manually (e.e they have 20 days where they can work that month).

I need to somehow relate the "actual days" to the "available days" and perform a calculation of actual days as a percentage of days available, most importantly for each month they are working.

Group by month is taken from the start date of the task.

How can I relate the available days in August for instance to the actual days allocated, and perform a calculation based on this?

Many thanks

 

[TimW]

hi b71
without the table structures I cannot be definate on how I would to it. But it looks if you need to use a subquery to collate the data into days worked in a month and then join this to the table showing available days. Using the individuals id as the join condition.
Perhaps if you post the table stuctures you have used then a more helpful answer will be forthcoming