I have a grid which has rows representing different employees with their salary payables/deductibles in the columns. The columns are generated dynamically at runtime as different departments have different payables/deductibles — the columns are not known until the grid is actually generated.
Now, I need to display these payables/deductibles properly formatted with thousands separators, but I also need to have a summary row totalling the different payables/deductibles for all employees.
Obviously summary rows dont work with columns of String type, but is there an elegant solution to this problem?
Like mentioned earlier, the columns names or the number of columns are not known until the grid is actually generated so I am not doing the totals myself in code.
Imported from legacy forums. Posted by corsair_moran (had 1968 views)