sum line in script

[Anonymous]

hi,

i have 2 tables order + orderline

i need to make group for kg in order.

the kg is in the order line.

i want to make in the script feild with sum kg per order .

how do i do it ?

thanks'

yarin.

[jonathandienst]

I assume that the order line has an order number field. Create a temporary table summing the mass grouping by order number, so the new table will contain order number and total mass in kg. You can then join this table to the order header or add it to the order header table with applymap().

If you provide a sample qvw with representative data, then someone will be able to provide more detailed assistance.

[tresesco]

Could you post a data sample with expected output explanation?

[deepakqlikview_123]

Hi,

PFA

I hope this would be your req

Thanks

[tamilarasu]

I just did some modification on the file. Reload the attached file after download.