Sum of column in fotter depend on some condition

[Rahul]

Hi


I need to sum on column in footer of grid. But it depends on condition

suppose i want A colum sum in fotter, Depnd on B column value if B column row value is null then no need consider that row 

    Column A  Colum B
            12                  30
            22                  
            44                   40
Sum :   56

only consider first and last row.
in sendon row b column is null

please help

[Eyup]

Hi Rahul,

You can use Custom column aggregate:
http://www.telerik.com/help/aspnet-ajax/grid-column-aggregates.html

Or you can define a GridCalculatedColumn:

<telerik:GridCalculatedColumn UniqueName="CalculatedColumnName" HeaderText="Calculated"
    DataFields="OrderID,Freight" Expression="{0}+{1}" Aggregate="Sum" DataType="System.Decimal">
</telerik:GridCalculatedColumn>

Hope this helps. Please give it a try and let me know if it works for you.

Regards,
Eyup
Telerik