Calculate: sum up columns or rows in datagrid(not in the advanced datagrid)

[jjyang]

Hi guys,

i have 3 cells(1,1,1) in the datagrid. they are in 3 different columns. i would like add them up and show the sum in the 4th column. i dont really have an idea.

any advice. (i am trying not to use advanced datagrid.)

thanks in advance.

mike

[box86rowh]

you could use a for loop starting with zero and ending 1 short of the number of rows, and build the running total and put that total in the final cell.

[jjyang]

hi,

thank you for the reply.

i think i did not make myself understand. i was thinking that 1 (col_1), 1(col_2), 1(col_3) and i want to add col_1 to col_3 together and show the sum in col_4.

hopefully you can understand me and give me another idea.

thanks really

Mike