Skip to main content
Solved

Adding component quantity from Kit Specification in generic inquiry

  • 5 October 2022
  • 1 reply
  • 96 views

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.

 

 

1 reply

BenjaminCrisman
Rank
Userlevel 7
Badge +4

Hi @atuljainajm ! For this issue you would need to group the results in order to be able to SUM the values.

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.

Reply


Terms & ConditionsCookie settings