Adding numbers in a grid

Q&A
1

Dear Sir/MDM,

I am using an invoice form. I have insert a grid widget into the form and has key in costs and product names . My question is can the grid function like Microsoft excel where I can create a sum value of all cost of a column on another field ?

Terry

2

You want to do that dynamically ? or you just to display the result of a query and formulas ?

3

When user key in column 1 and 2 values, column 3 will get the sum of column 1 and 2 values, for eg.

Column 1 | Column 2| Column3 |
1 | 2 | 3
2 | 2 | 4
3 | 3 | 6