Here is what I want to do: I want to have a datagrid that displays a total value for each row. Lets say for example I have a datagrid. In this datagrid on each row I have five columns. Of the five columns four are for the user to input numbers. The fifth column is the the "total" column which is the result of a formula that calculates the previous four columns on that row in which the user inputs the numbers.
example:
Row 1: (1st COLUMN)200 + (2nd COLUMN)300 - (3rd COLUMN)100 + (4TH COLUMN)90 = (TOTAL COLUMN)490
Row 2: (1st COLUMN)400 + (2nd COLUMN)300 - (3rd COLUMN)50 + (4TH COLUMN)90 = (TOTAL COLUMN)740
ROW 3: etc...
Ive been working on this for hours does anyone have any suggestions on how to do that?
Any help is greatly appreciated!