SOLVED
Calculate Regular and OT Pay
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ewassell
8 - Asteroid
‎11-04-2024
04:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Output
3 REPLIES 3
Wesley Mendonca
9 - Comet
‎11-04-2024
05:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎11-04-2024
05:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Boy was I overcomplicating this! Thanks so much - I feel dumb but happy!
Raj
16 - Nebula
‎11-04-2024
05:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ewassell
find all the calculations attached
mark done if solved.
