+3Hello 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!
Best answer by TheTimeSavingCo
Try something like:
{Total invoiced} *
SWITCH(
{Driver},
"DIMA", 0.13,
"ALEX", 0.7
)
+31Try something like:
{Total invoiced} *
SWITCH(
{Driver},
"DIMA", 0.13,
"ALEX", 0.7
)+3Try something like:
{Total invoiced} *
SWITCH(
{Driver},
"DIMA", 0.13,
"ALEX", 0.7
)That worked perfectly. Thank you so much!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.