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!!
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!!
Please give the column names and type that are available in the table where you want the formula column to added.
Hey Rey. Here is a screenshot!
Hey Rey. Here is a screenshot!
Try this formula:
MIN(MAX(({Total} * .1), 10.0), 25.0) + IF({Delivery?} = 1, 20.0, 0.0)
Try this formula:
MIN(MAX(({Total} * .1), 10.0), 25.0) + IF({Delivery?} = 1, 20.0, 0.0)
You are the man, REY!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.