Hi All,
I am trying to make a new column in the below GI which contains the sum of ‘Component Qty’ for an ‘Inventory ID’.
Suppose for Inventory ID JE17882TK, the component quantity is 3 and 2. The new column should have 5 as value.
Thanks.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/a41e13dd-d9e1-468a-a615-919e7fee2a4c.png)
Hi All,
I am trying to make a new column in the below GI which contains the sum of ‘Component Qty’ for an ‘Inventory ID’.
Suppose for Inventory ID JE17882TK, the component quantity is 3 and 2. The new column should have 5 as value.
Thanks.
Hi
The new column will only see the single value of the line and there isn’t a formula to check the value of a higher line (that I’ve seen) and then add to its current value.
Use a grouping on the item and use the Aggregate Function of SUM and it should show you what you’re looking for in the original value Component Qty field.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.