Jump to content

Complex Calc to find workload cacpacity


This topic is 5667 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5667 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.