Setting specific formula based on Driver Field

[mike060410]

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!

 

[TheTimeSavingCo · Accepted solution]

Try something like:

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

[mike060410]

That worked perfectly. Thank you so much!