Column total solved


How do I get the sum of a column of all rows on a DataGrid?



There is an example here:



After much trial and error, I was able to get a column total displayed as shown in the DataGrid component properties and events documentation. Very important to do everything in the correct sequence. First add code in the LoadData under events. Do not cut and paste. Key everything in as prompts and drop downs will appear that you need to select. Then add code for Footer Template for the column you want the total. To get 2 decimal positions to display, use the ToFixed() parameter in the expression in the Footer Template. Now I'm trying to figure out how to recalculate the total when you use the filter for any column. Any help will be appreciated. I'm assuming some kind of event needs to be initiated.