PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Total Error

  1. 3dp
    Member

    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.

    User selects Buyer Type 1, Buyer Type 2 or Buyer Type 3 (Radio Buttons)

    There is a product.
    There is a product, but used for shipping (flat rate per item)
    There is a product, but used for sales taxes (conditional based on state & buyer type. Must be buyer type 1 and in a particular state).

    If Buyer Type 1 is selected AND the correct state is selected, the Sales Tax calculation is run (and shows correctly).

    Shipping is calculated (quantity of product * a flat rate number). This is correct.
    WIth a quantity of 1, all calculations are correct.
    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.

    For anything more than 1, the pattern is Product * Quantity * Quantity + Shipping * Quantity + Sales Tax.

    If Buyer Type 2 or 3 is selected, the total calculation is correct regardless of quantity.

    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.

    Posted 12 years ago on Friday May 18, 2012 | Permalink
  2. David Peralty

    So basically an extra * Quantity is being added to your formula?

    Posted 12 years ago on Friday May 18, 2012 | Permalink
  3. 3dp
    Member

    Yes. This is what I have for formulas:

    • Product: {Quantity:9} * 6.99
    • Tax: {Quantity:9} * 6.99 * .04
    • Shipping: {Quantity:9} * 5.00

    It's only in the TOTAL field that the calculation is wrong.

    Posted 12 years ago on Friday May 18, 2012 | Permalink
  4. Can you export this form and send the XML file to me to rob@rocketgenius.com and reference this post.

    Posted 12 years ago on Monday May 21, 2012 | Permalink
  5. 3dp
    Member

    Thanks to Rob's help, I was able to solve the problem.

    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.

    Posted 12 years ago on Tuesday May 22, 2012 | Permalink
  6. Glad to help out!

    Posted 12 years ago on Tuesday May 22, 2012 | Permalink

This topic has been resolved and has been closed to new replies.