Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Calculate Regular and OT Pay

ewassell
8 - Asteroid

I am given a total pay amount and need to calculate the Reg and OT pay rates based on the number of hours worked.  I know that OT is 1.5 of Reg pay.  I know how to do this using Algebraic equations but how do I do it in Alteryx?

 

X= RegHours

Y=OT

 

{RegHours}X + [OTHours}y = {Total}

1.5X = Y

{RegHours}X + [OTHours}(1.5x) = [Total]

 

3 REPLIES 3
Wesley Mendonca
9 - Comet

To solve this problem in Alteryx, you can create a workflow that calculates the regular (Reg) and overtime (OT) pay rates based on the given total pay and the relationship between the two rates.
I built an example with you data, see if this can help you. 

ewassell
8 - Asteroid

Boy was I overcomplicating this!  Thanks so much - I feel dumb but happy!

 

Raj
16 - Nebula

@ewassell 
find all the calculations attached
mark done if solved.

Labels
Top Solution Authors