- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 09, 2024 08:52 AM - edited ‎Apr 09, 2024 08:58 AM
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!
 
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 09, 2024 07:10 PM
Try something like:
{Total invoiced} *
SWITCH(
{Driver},
"DIMA", 0.13,
"ALEX", 0.7
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 09, 2024 07:10 PM
Try something like:
{Total invoiced} *
SWITCH(
{Driver},
"DIMA", 0.13,
"ALEX", 0.7
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 09, 2024 07:24 PM
That worked perfectly. Thank you so much!
