
1. Re: Conditional content within a field
philmodjunk May 10, 2013 12:57 PM (in response to DaveM)To answer that question requires a more detailed understanding of how you have organized your data.
How, at least "on paper", are the 8 hour day and 12 hour day totals computed?
How is your table structured?
Are you computing actual hours worked from a list of people who have "clocked in" in some manner or are you computing an estimated value based on the number of people?

2. Re: Conditional content within a field
DaveM May 10, 2013 2:28 PM (in response to DaveM)Hi Phil,
As far as the numbers go, I have a field that calculates each worker at an hourly rate  ie: $10 per hour for 8 hours is $80. I also have a field that calculates, for example, time and a half after 8 hours  ie: $10 per hour for 8 hours plus 4 hours at $15 per hour (12 hour day) is $140. I have an additonal summary field that aggrigates the totals for all of the manpower for the day, based on the previously mentioned timeframes  ie: 10 guys for 8 hours is $800, 10 guys for 12 hours is $1400.
What I have is actually a little more complicated, as there are both time and a half and double time considerations, so the above is just for simplicity's sake. All those fields are functioning fine.
This budget is for a projected project, so it's not actual hours, but what we're estimating  so, a "rehearsal day" will be assumed to be an 8 hour day, and a "work" day would be a 12 hour day. Each day is an "Event" which has a field that designates it as one of these categories.
What I'm hoping to be able to do is to create a summary budget that shows a projected cost for manpower for the day, and to have the total in the field controlled by the day's designation as a rehearsal day or a work day. I've got everything functioning to this point  other than having the DB automatically store the correct amount.
Thanks!

3. Re: Conditional content within a field
philmodjunk May 10, 2013 10:36 PM (in response to DaveM)Is this all in one record (all employees get the same rate?) or do you use a related table to list individuals and their pay rates?
If this is all in one record where you would specify the number of people, the type of "day" and also have your calculation fields, then all you need is a calculation field with an If or Case function that selects the correct calculation field for the type of day:
If ( DayType = "work" : 12HourDayCalc ; 8HourDayCalc )
If you have more than two types of days, use Case in place of If.

4. Re: Conditional content within a field
DaveM May 11, 2013 7:58 AM (in response to DaveM)Fantastic! Thanks!