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!