Help

Re: Looking for help writing formula for pay earned based on variable

Solved
Jump to Solution
304 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ryan_Anderson1
4 - Data Explorer
4 - Data Explorer

I’m looking for help writing a formula to show what pay a staff member has earned based on a variable.

I have hours worked (at 30 per hour for one role, and 25 for a different role), and trainings complete at 50 per session.

How do I write a formula that looks at the “role assigned select field” and calculates based on the correct rate of pay?

Thanks,

1 Solution

Accepted Solutions
JonathanBowen
13 - Mars
13 - Mars

Hi @Ryan_Anderson1 - you can do something like this:

IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25})

and then to include the trainings you can extend this with:

IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25}) + {trainings complete field} * 50

For 2 roles, an IF statement is fine. If you end up with more than this, you can move to SWITCH statement, which is often easier than multiple nested IFs

See Solution in Thread

3 Replies 3
JonathanBowen
13 - Mars
13 - Mars

Hi @Ryan_Anderson1 - you can do something like this:

IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25})

and then to include the trainings you can extend this with:

IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25}) + {trainings complete field} * 50

For 2 roles, an IF statement is fine. If you end up with more than this, you can move to SWITCH statement, which is often easier than multiple nested IFs

Thank you! I’ll start there and see if I have any issues, thank you!

This isn’t correct - should be:

{Hours field} * 25