Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Calculate OT hours - if over 8 and/or over 40

ewassell
8 - Asteroid

My head hurts on this one! I am trying to calculate overtime based on 2 conditions. 

If your WcState (in Rates file) is equal to CA, you get Overtime over 8 hours a day (Marta Jones)  (Sean Jones) AND overtime for hours over 40 as well (Sean Jones).

if your WcState (in Rates file) is equal to anything else, you get overtime for hours over 40 a week. - (Katie Jones)

 

Sean Jones is not working correctly.  He should have 40 hours Regular (28 hours + 12 hours) at $80 VNDLY Pay Rate ST Hr AND (7 + 2 + 4 hours) at overtime rate $120 VNDLY Pay Rate ST Hr.

 

I don't know how to calculate the hours over 40 he should get overtime for, they are going into the regular time calc.

 

 

 

1 REPLY 1
griffinwelsh
12 - Quasar

@ewassell I didn't want to dig into your whole workflow but see the attached solution for calculating the overtime hours. 

Labels