Trouble with Rule Calculations

corradomatt

I've got 3 BO's - Job, Staff and StaffHours. I want to use StaffHours to calculate a staff members hours for the week and store it in an attribute called WorkHours. Each week the staff member might do several Jobs which are stored in the Job BO under an attribute called Hours.

I used "StaffHours.WorkHours=SUM Job.Hours" as a rule in StaffHours and this calculated the total time for all staff members. But I need it to only grab the total hours for an individual instance of the Staff BO.

I've tried almost everything I can think of to isolate just 1 staff members hours with no luck. I've read through the manual and watched all the videos here a bunch of times with no results.

Any advice? Am I making things to complicated? Any suggestions are helpful.

corradomatt

Here are a few of the rules I've tried....

StaffHours.WorkHours=SUM Job.Hours WHERE (StaffHours.Staff=Job.Hours)

StaffHours.WorkHours=SUM Job.Hours WHERE (Job.Hours=StaffHours.Staff)

StaffHours.WorkHours=SUM Job.Hours WHERE (StaffHours.Staff IN Job.Hours)

StaffHours.WorkHours=SUM Job.Hours WHERE (Job.Hours IN StaffHours.Staff)

StaffHours.WorkHours=SUM Job.Hours WHERE (StaffHours.Staff IN Staff.Job)

StaffHours.WorkHours=SUM Job.Hours WHERE (StaffHours.Staff IN Job.Staff)

StaffHours.WorkHours=SUM Job.Hours WHERE (Job IN Staff.Job)

corradomatt

OK, I figured it out finally - probably too much caffine and not enough sleep that night. 🙂

I ended up being....

StaffHours.WorkHours=SUM Job.Hours WHERE (StaffHours.Staff=Job.Staff)

...just in case someone is interested.