I have a data grid which contains two numeric columns which are generated from users inputting data into a form. I need to write something which can total these two columns separately. I have tried adding a behaviour and then a formula but the columns in the data grid are not available from the formula listing.
Instead of using a data grid why don’t you use a table. Perform your calculation within the table. Data grids specifically pull data from another location without giving you the option to modify the data whereas a table gives you options to do what you are seeking.