
1. Re: Hours Multiplied by pay rate
JonasGysin Aug 11, 2016 2:14 AM (in response to chris.tidey@tideyelectrical.com)HI Chris,
So to recap, you have:
rate 1 : mofr, first 8 h, 100 %
rate 2 : mofr, >8h; 133%
rate 3 : sat, 150%
rate 4 : sun, 200%
You would like to know how much hours of every rate a person totalizes per given day or week, moth etc.
Correct?
If yes, I would solve it like this:
Assuming you have:
 1 field called total hours that returns the total hours worked on a given day
 one called day wich is returning the day number
 you're calculating on a per day basis.
rate 1 = total hours if not greater then 8 and weekday not greater than 5
rate 2 = if total hours is bigger then 8 and weekday not greater than 5, total hours  8
rate 3 = if weekday = 6 ; total hours
rate 4 = if weekday = 7 ; total hours
Use the if() or case() functions.
If you don't have the fields like stated above, you can use variables with the let() function.Got it?
I can't tell if it's the best or easiest way but it's probably how i would do it.

2. Re: Hours Multiplied by pay rate
chris.tidey@tideyelectrical.com Aug 11, 2016 11:16 PM (in response to chris.tidey@tideyelectrical.com)1 of 1 people found this helpfulHi Jonas Gysin,
Thanks for your quick response.
Would the calculation be
if total hours > 8
if total hours > 8 < 5 = total hours  8
Is this right?
also should rate 3 and 4 be
if weekend = 6;total hours??
Can you right the calculation out so I know I'm not being stupid!! haha

3. Re: Hours Multiplied by pay rate
JonasGysin Aug 12, 2016 12:45 AM (in response to chris.tidey@tideyelectrical.com)1 of 1 people found this helpfulHi Chris,
Come on, you'll never learn if other people do your homework.
I'll give you the rate 3:
If ( day = 6 ; total_hours * 1.5 )
You may want to check ou the filemaker help (FileMaker Pro 15 Help)
logical functions : FileMaker Pro 15 Help
Kindly,
Jonas

4. Re: Hours Multiplied by pay rate
chris.tidey@tideyelectrical.com Aug 13, 2016 7:39 AM (in response to JonasGysin)Haha thanks very much Jonas I'm useless at If commands #stilllearning

5. Re: Hours Multiplied by pay rate
JonasGysin Aug 15, 2016 1:39 AM (in response to chris.tidey@tideyelectrical.com)You're welcome!
Give it a try, read the few pages of the help file I linked, everything is there.
You can test your code directly in FM. Worst case : It doesn't work.
If you're stuck, post back here. If you manage it, you won't be useless at it anymore!

6. Re: Hours Multiplied by pay rate
chris.tidey@tideyelectrical.com Aug 23, 2016 3:37 AM (in response to JonasGysin)I tried this and it didn't work.

7. Re: Hours Multiplied by pay rate
JonasGysin Aug 25, 2016 2:33 AM (in response to chris.tidey@tideyelectrical.com)Ok well can you post the commands you wrote? We'll see from there.