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 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.