Skip to Content
0
Former Member
Jul 23, 2010 at 02:27 AM

UDF to sum the line items

836 Views

Hi,

I am looking for UDF to add data from multiple line items and create single target item. The line items are in order. We need to keep adding the value until their is change in key.

Source

Field1 key-Field2 Filed3

name1 1001 100

name1 1001 50

name1 1001 50

name2 1002 50

name2 1002 20

name2 1002 50

Target

name1 1001 200

name2 1002 120