Skip to main content

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!

 

Try something like:

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

Try something like:

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

That worked perfectly. Thank you so much!

Reply


Terms & Conditions