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]
Solved! Go to Solution.
Boy was I overcomplicating this! Thanks so much - I feel dumb but happy!
@ewassell
find all the calculations attached
mark done if solved.