Marie Taylor Harper Avatar

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.
Thanks for the udpate Marie.
Tue Nov 05 2024
| 4 Replies