kinetic
Member
I have a form that I need to perform several percentage calculations on for taxes and gratuity. So I have 3 "total" fields. The first just totals up all the products. The second I need to take the product subtotal and add 10% to it. So I wrote the following formula:
'( {Product Subtotal (Price):33.2} * 0.10) + {Product Subtotal (Price):33.2}'
This doesn't seem to be working though. Am I missing something?
Do you have a link to your form so I can visually see this?
Can you export the form and send the XML file to me to rob@rocketgenius.com so I can take a look? Please reference this post in your email.
kinetic
Member
Here is a screenshot of the relevant portion of the form.
https://skitch.com/jflint/8489u/order-form
I have marked the quantity of "Bailey's" as 1, which put the price in the Liquor subtotal. The "net subtotal" needs to take the liquor subtotal, multiply it by 10% (0.1), then add that value back to the liquor subtotal to get the net subtotal. So I tried using
'({liquor subtotal} * 0.1) + {liquor subtotal}'
That didn't work. But, if I put the same code in the net subtotal that i am using the liquor subtotal (price * quantity) + (price * quantity), etc, that works.
Resolved via email.
