
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2020 10:00 AM
Hello! I am having trouble creating a formula to calculate my service fee.
Our fee is 10% of the order total (min fee $10, max $25.) We charge and extra $20 IF the order is for delivery.
Please Help!!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2020 11:02 AM
Try this formula:
MIN(MAX(({Total} * .1), 10.0), 25.0) + IF({Delivery?} = 1, 20.0, 0.0)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2020 10:36 AM
Please give the column names and type that are available in the table where you want the formula column to added.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2020 10:41 AM
Hey Rey. Here is a screenshot!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2020 11:02 AM
Try this formula:
MIN(MAX(({Total} * .1), 10.0), 25.0) + IF({Delivery?} = 1, 20.0, 0.0)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2020 11:22 AM
You are the man, REY!
