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.

Quantity calculation

  1. Hello, I'm trying to use the new calculations features and running into trouble.

    I have a form with a number of different products with separate quantity fields. I'm trying to calculate a sub-total which I'll then use to calculate surcharges. I figured this would be a matter of creating a Number field who's value is the sum of all the products of each quantity and each price...e.g.

    Sub-Total (number) =
    Price1 x Quantity1 + Price2 x Quantity2 etc.

    The number always came up zero. I decided to simplify things and check each part and found that:
    Sub-Total (number) = Quantity1

    always returned zero no matter what Quantity1 actually was. Has anyone else had this problem? Am I doing this incorrectly?

    Just to recap:
    - I create a Number field
    -I enable Calculation
    -I choose an arbitrary Quantity field from the "Insert Merge Tags" drop down
    -I save and view the form
    -I punch in a number for the Quantity
    -The Number field does not update
    -If I set the Number field to the Price, however, it does reflect it, but that never changes anyway.

    Help is appreciated!

    Posted 12 years ago on Friday May 11, 2012 | Permalink
  2. Anybody have any tips? Perhaps my question was too wordy....I'll simplify it:

    How do I calculate a sub-total on a form with quantities in order to calculate taxes, shipping charges etc?

    Posted 12 years ago on Tuesday May 15, 2012 | Permalink
  3. You will need to add up all of the product x qty in groupings to get this to work. Can you export your form and send the XML file to me to so I can take a look. Please reference this post in your email.

    Posted 12 years ago on Tuesday May 15, 2012 | Permalink
  4. Never mind....I figured out what the problem was. In the Merge tags there are options for Product1 (name), Product1 (price) and Product1 (quantity). My products, however, are all using separate quantity fields. I was using Product1 (quantity) in the equation rather than the separate Quantity field which I didn't notice in the Merge Tag list. Thanks for the reply, though!

    Posted 12 years ago on Tuesday May 15, 2012 | Permalink
  5. Right on, glad you got it working. Thanks for letting us know.

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

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