Calculating dynamic values from dropdown lists

[BlakkyLIVE]

Hi all, here's the noob question of the day

I'm creating an invoice form in LiveCycle Designer and I'm totally stuck at tax calculations:

for each product you're able to choose between two tax percentages from a dropdown list and, at the end of the form, I want to show a total amount of each tax.

product	qty	unit price	vat	net price
red shoes pack	2	20$	4%	40$
black shoes pack	1	25$	4%	25$
white umbrella	1	10$	7%	10$

total net price	75$
+ TAX 4%	2.60$
+ TAX 7%	0.70$
Total	78.30$

How can I set the + TAX 4% and + TAX 7% fields to grab their respective product rows?

Sorry for my bad english.. I hope you get the question!

[Former Community Member]

You woudl have to look at each row inside of a for loop and then determine if that row had 4% or 7% tax. Then you coudl keep a running total of the tax for you calcultions such that when the for loop ended you would have the 4 and 7% totals calculated.

Make sense?

Paul

[BlakkyLIVE]

uhm yes it does, can you suggest a practical example for someone who's not really a coder?

[BlakkyLIVE]

back to this form and still stuck.. can anyone provide a code example, please?

[Former Community Member · Accepted solution]

If you send your form to LiveCycle8@gmail.com I will code it up for you to give you the idea of how to do it. Please include a description of what you want done in the email.

Paul