https://legacy.forums.gravityhelp.com/topic/total-error Gravity Support Forums Topic: Total Error en-US Mon, 20 Apr 2026 04:29:52 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/total-error#post-59836 Tue, 22 May 2012 10:06:00 +0000 Rob Harrell 59836@https://legacy.forums.gravityhelp.com/ <p>Glad to help out! </p> https://legacy.forums.gravityhelp.com/topic/total-error#post-59834 Tue, 22 May 2012 10:05:14 +0000 3dp 59834@https://legacy.forums.gravityhelp.com/ <p>Thanks to Rob's help, I was able to solve the problem.</p> <p>If you're getting calculation errors due to having product visibility based on user choices try using a regular number field for the quantity. The Pricing Fields quantity seems to have some issues sorting out logic. The regular number field for quantities works very well. </p> https://legacy.forums.gravityhelp.com/topic/total-error#post-59631 Mon, 21 May 2012 11:23:09 +0000 Rob Harrell 59631@https://legacy.forums.gravityhelp.com/ <p>Can you export this form and send the XML file to me to <a href="mailto:rob@rocketgenius.com">rob@rocketgenius.com</a> and reference this post. </p> https://legacy.forums.gravityhelp.com/topic/total-error#post-59474 Fri, 18 May 2012 17:43:47 +0000 3dp 59474@https://legacy.forums.gravityhelp.com/ <p>Yes. This is what I have for formulas:</p> <ul> <li>Product: {Quantity:9} * 6.99</li> <li>Tax: {Quantity:9} * 6.99 * .04 </li> <li>Shipping: {Quantity:9} * 5.00</li> </ul> <p>It's only in the TOTAL field that the calculation is wrong. </p> https://legacy.forums.gravityhelp.com/topic/total-error#post-59468 Fri, 18 May 2012 17:26:54 +0000 David Peralty 59468@https://legacy.forums.gravityhelp.com/ <p>So basically an extra * Quantity is being added to your formula? </p> https://legacy.forums.gravityhelp.com/topic/total-error#post-59464 Fri, 18 May 2012 17:02:41 +0000 3dp 59464@https://legacy.forums.gravityhelp.com/ <p>I'm getting a weird error at the total... it appears to be adding one field to the total twice. If remove a different field, the error goes away.</p> <p>User selects Buyer Type 1, Buyer Type 2 or Buyer Type 3 (Radio Buttons)</p> <p>There is a product.<br /> There is a product, but used for shipping (flat rate per item)<br /> There is a product, but used for sales taxes (conditional based on state &amp; buyer type. Must be buyer type 1 and in a particular state).</p> <p>If Buyer Type 1 is selected AND the correct state is selected, the Sales Tax calculation is run (and shows correctly).</p> <p>Shipping is calculated (quantity of product * a flat rate number). This is correct.<br /> WIth a quantity of 1, all calculations are correct.<br /> With 2 or more quantity, things go wonky. The product price is $6.99, flat rate shipping is $5.00 per item. With no taxes, it's $11.99 for 1.</p> <p>For anything more than 1, the pattern is Product * Quantity * Quantity + Shipping * Quantity + Sales Tax.</p> <p>If Buyer Type 2 or 3 is selected, the total calculation is correct regardless of quantity.</p> <p>I've looked at the exported XML and I don't see anything strange. I've tried opening the form in different browsers and the error still shows up. </p>