To post a comment, please sign in with your email.
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.
Asked by Marie Taylor Harper
10 hours ago
All Replies (3)
Vipin
9 hours ago
HI Marie, When you enable the bulk discounts option, you must specify the amount for different quantities. Since you have set up the unit price (see below), the calculations are not working correctly.
Vipin
9 hours ago
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.
Marie Taylor Harper
7 hours ago
Thank you Vipin! Everything is clear now and it works for the two that I just configured :D
Have an amazing Day!!
Click to add files
Related Questions
See related queries.