I am trying to set up a cal that will tell me how many hours of work I have in a given day. My fields are defined as follows:

Due date of Job;

Optimal manufacturing date, which is 7 days before the due date;

Amount of time required to manufacter the job. So what I need to do is find all the jobs due on a given day and add up the hours and compare the result to the available hours in a day. Sounds simple, but I would like to be able to see capacity for a longer period of time. So I would like it to calculate as I enter new work and as I get close to capacity, give me feedback indicating that.

This shouldn't be too difficult if you always complete a job entirely on the Build Date.

Create a relationship joining BuildDate with BuildDate, and a global field gWorkHours which holds the number of work hours in a given day.

case(sum(BuildDate::BuildHours)<=gWorkhours; "Enough Time"; "Overscheduled")

You can adjust the case statement to return the results you want.

If you need to calculate multiple jobs with multiple build dates that span multiple days, the situation gets more complex. You would need to provide more information in this case.

-Raz

Thanks, but I got there another way. I made a Running Total time field and it is working great.