How to take total of dynamically created template columns in footer

[Manish]

Hi,

I want total of a column in footer but i am creating my columns dynamically and it is asp label type and i need Total of that column in footer

I am using this code. But it returning a error page with error

Sum is not supported for type "System.Object".

but when i comment line denoted with * than page works fine but not able to display total. Please help

  templateColumn = new GridTemplateColumn();
  controlID = "lbl_Total" + colCounter.ToString();
   templateColumn.ItemTemplate = new CreateItemTemplate("Label", this, controlID, null, 27, "16px", colCounter, dtSchedule.Rows.Count);
  templateColumn.HeaderText = dtGetColumnsNameForGrid.Rows[colCounter - 1]["HeaderText"].ToString();
  templateColumn.UniqueName = dtGetColumnsNameForGrid.Rows[colCounter - 1]["UniqueName"].ToString();
  templateColumn.DataField = dtGetColumnsNameForGrid.Rows[colCounter - 1]["UniqueName"].ToString();
 templateColumn.FooterText = "Total: ";
*****  templateColumn.Aggregate = GridAggregateFunction.Sum;

[Princy]

Hi,

I am not quite sure about your issue. Make sure that you have defined the datatype for the column as shown below.
C#:

templateColumn.DataType = typeof(System.Int32);
templateColumn.Aggregate = GridAggregateFunction.Avg;

Thanks,
Princy.