Calculate total at footer

[Saran kumar]

hi please find attached the radgrid image, where in all the columns are grid bound columns, i just wanna calculate the total of the values at footer.

pleases help.

<Columns>
                        <telerik:GridBoundColumn UniqueName="Month" HeaderText="Month" DataField="Lead_Month"
                            HeaderStyle-Width="200px" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="Leads" HeaderText="Leads" DataField="Intake"
                            HeaderStyle-Width="150px">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn UniqueName="Clients" HeaderText="Clients" DataField="Client"
                            HeaderStyle-Width="150px">
                        </telerik:GridBoundColumn>

                    </Columns>

[Princy]

Hi Saran Kumar,

The GridBoundColumn object has an Aggregate property that you can set to specify a function for aggregating the values that the column displays. Set Aggregate property to "Sum".

ASPX:

<telerik:GridBoundColumn DataField="Leads" DataType="System.Int32" HeaderText="Leads"
    SortExpression="Leads" UniqueName="Leads"  Aggregate="Sum">
</telerik:GridBoundColumn>

Also set the ShowFooter property of grid to True.

Checkout the documentation for more information: Column Aggregates

Thanks,
Princy.

[Saran kumar]

Hi thanks for your reply, i have tried it with using the datatype = "system.int32" its thowing an exception "Specified cast is not valid.".
then i used system.string its too throwing a exceptions "system.object does not support".

please help.

[Princy]

Hello Saran,

It seems your column is of string datatype. Thus, you could manually calculate the sum for the column from code-behind. You can refer to the section 'Programmatic solution' under the following document to understand how to manually get the totals for a column in its footer:
Totals in grid footers

Thanks
Princy.