Addition of numbers in text fields with a twist

Question

Hello every onei have a pdf document that contains usual columns and rows having text fields for data entry.First column contains items names and second column is for the quantity of each item. Condition is that one item e.g. item "A" can occupy ONE OR MORE THAN ONE ROW and the table contains more than one item.What i need is calculate the total quantity of each item i.e. item "A", "B" and so on, separately in a different text field. But remember the cumber of rows occupied by each item may vary every time the table is filled. For more clarification the table is given below:ItemQuantityA5A10A15B2B4B6Thanks in advance

try67 · Accepted Answer

Let's say the fields are named Item1, Item2, etc., up to Item6 and Quantity1, Quantity2, etc.

You can use this code as the custom calculation script of the field that shows the total amount of "A" items:

var total = 0;
for (var i=1; i<=6; i++) {
    if (this.getField("Item"+i).valueAsString=="A") total+=Number(this.getField("Quantity"+i).valueAsString);
}
event.value = total;

Item	Quantity
A	5
A	10
A	15
B	2
B	4
B	6

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.