Formula for Commission Pay

Brad_Holley · ‎Jan 29, 2022

Hi all! We have an employee paid in part on commission. I’m attempting a formula to calculate the pay. Here are the factors:

If the appointment shows (pays $25)
If purchase is made (pays based on source of purchase)
Source 1: $50
Sources 2&3 : $100

So I’m looking for a formula that can display the amount if an appoint shows and no purchase is made and also if an appointment shows and a purchase is made via any source.

Thanks in advance for the help!

Justin_Barrett · ‎Jan 29, 2022

Welcome to the community, @Brad_Holley! :grinning_face_with_big_eyes: The formula should be pretty easy to create, but we’ll need to know more about your base design. What field types are you using to track when an appointment shows and purchases are made from the available sources? If you can share screenshots, that would be helpful (even if you have to mask them to hide private data).

Brad_Holley · ‎Jan 30, 2022

Brad_Holley · ‎Jan 30, 2022

Single select fields for the source, appt. shown and vehicle purchased.

Justin_Barrett · ‎Jan 31, 2022

Thanks. Here’s a rough outline that you should be able to adapt with the specific options in your {Source} field in the SWITCH() function arguments, with the formula field formatted as currency:

IF({Appt. Shown} = "Yes", 25) +
IF({Vehicle Purchased} = "Yes",
    SWITCH(
        Source,
        "Option 1", 50,
        "Option 2", 100,
        "Option 3", 100
    )
)