Help

Setting specific formula based on Driver Field

Topic Labels: Automations Formulas
Solved
Jump to Solution
241 2
cancel
Showing results for 
Search instead for 
Did you mean: 
mike060410
4 - Data Explorer
4 - Data Explorer

Hello Everyone,

I am having a hard time with a specific formula. I want to set a formula that will calculate a certain percentage based on what driver is selected in the driver field. 
Example: for the Dispatch % field i need a formula that will go like this. If driver is Dima set Dispatch % to be {Total invoiced} *.13 if Driver is Alex set dispatch % to be {Total invoiced} *.07 Thank you for the help!

Screenshot 2024-04-09 084718.png

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try something like:

{Total invoiced} *
SWITCH(
  {Driver},
  "DIMA", 0.13,
  "ALEX", 0.7
)

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try something like:

{Total invoiced} *
SWITCH(
  {Driver},
  "DIMA", 0.13,
  "ALEX", 0.7
)

That worked perfectly. Thank you so much!