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