Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate 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