Adding numbers in a grid
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
No answers yet.
Comments
You want to do that dynamically ? or you just to display the result of a query and formulas ?
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