Repeating Table With Drop Down Fields

40andinschool2 — Tue, 28 Jan 2014 17:05:17 GMT

I will try to convey this so it makes sense to someone besides me. I have a webservice that populates a repeating table. The repeating table could have up to 70 diferent rows. Each row will have three % fields (c, d, and e - below). I need for each of the Sales and GP totals to be calucluated by row based on the user input % values.

					c			d			e
					USER			USER			USER
			a	b	INPUT			INPUT			INPUT
CY	FAC	DEPT	SALES	GP	%	SALES	GP	%	SALES	GP	%	SALES	GP
12	47921005	1	30,331	7,514	10	33,364	8,265	25	37,914	9,393	15	43,601	10,801
12	47921005	2	571	217	15	657	250	30	742	282	15	854	324.42
FROM A WEB SERVICE CALL						CALCULATED			CALCULATED			CALCULATED
						(A*C)+A	(B*C)+B		(A*D)+A	(B*D)+B		(A*E)+A	(B*E)+B

I am looking for a way (using rules) to allow the user to enter the various % values (column c, d, and e) and calculate the new sales and GP totals.

Clear as mud? Any assistance would be greatly appreciated. I have been spinning my wheels far to long.

Thank you.

Chad

General

Repeating Table With Drop Down Fields