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