some calculation problems !

[make]

hi there,
following problem.
I have a temp-table like this :
Artikel_nr Value

1111111 1
1111111 1
1111111 2
3333333 1
3333333 2
2222222 1
2222222 1

What i need is this

Artikel_nr Value

1111111 4
2222222 2
3333333 3
I need this in a new temp-table.

Can you help me ?

Make

 

[Henri de Vos]

Hi Make.

maybe this can help you:

for each temp-table-1 break by artikel_nr no-lock :

if first-of(temp-table-1.artikel_nr) then do:
create temp-table-2.
assign temp-table-2.artikel_nr = temp-table-1.artikel_nr.
end.

assign temp-table-2.value = temp-table-2.value + temp-table-1.value.

end.

Hope this helps.

 

[Norman Biggar]

Long live the ACCUMULATE function!

DEF temp-table2 LIKE temp-table1.
FOR EACH temp-table1
BREAK BY temp-table1.artikel_nr:
ACCUMULATE temp-table1.artikel_val(SUB-TOTAL BY temp-table1.artikel_nr).
IF LAST-OF(temp-table1.artikel_nr) THEN DO:
CREATE temp-table2.
ASSIGN temp-table2.artikel_nr = temp-table1.artikel_nr
temp-table2.artikel_val = (ACCUM SUB-TOTAL BY temp-table1.artikel_nr temp-table1.artikel_val).
END.
END.

 

[make]

Thanks Henry , Norman for help (n.t.)

.