Marie Taylor Harper
Coaching Talk ⏺ Heal ⏺ Create Combo Sign Up and Payment
| United States
Posts
Support
Hello Support,
I have a form with 10 unique items on it; each can be purchased multiple times (between 1 and 5 inclusively). There is also a discount which was tallied into the pricing chart for the item as shown below.
Quantity Price
1. 30 each
2 27.5 each
3 27.5 each
4 25 each
5. 25 each
In the following examples, I have certain expectations which I am not finding to be true so I am expecting that I am not doing my calculations correctly which may or may not be possible within the application:
1. If a customer buys 1 of item 1, they should be charged $30. This is true.
2. If a customer buys 1 of item 1 and 1 of item 2, then they should be charged $60. This is also true.
3. If a customer buys 3 of item 1 and 1 of item 2, the math changes. They should be charged $77.50 for item 1. They should be charged $30. The total they should be charged is $102.5 dollars, but I either get a total of $27.50 or $105 as I am not able to calculate a subtotal for the individual items.
My logic would be as follows for a single item which would give a subtotal for a specific item which I tried to do in one of the add on fields for the item:
IFS(QUANTITY < 2, 30, IFS(QUANTITY < 3, QUANTITY * 27.5, QUANTITY * 25))
When a total is generated, I would expect to add up all of the subtotals:
ITEM_1 + ITEM_2
What I am seeing at the end is the overall quantity of items for all options which doesn't work out well for calculating the correct price. Hence I would see 4 which would result in a net total of $100 for my example which is a lost of $2.50.
Can you explain how to tally up this form correctly? Or provide a KB Article that explains this in more detail as the articles I did see along with the documentation about the different fields isn't as helpful as I would hope for.
Login to Neartail > click on the form to open it > Edit page will be displayed > In the Edit page, click on the product to select it > click on the settings gear icon > Product settings page will be displayed > click Bulk discount > enter the amount for the different quantity options and click Save. Repeat the steps for other products in the form. When you use the TOTAL() formula, it will automatically calculate the order amount based on the price and the bulk discounts setup for the products.
Mon Nov 04 2024
| 3 Replies