[Solved] Add Column with sum result of other 2 columns

[Eloy]

I have this code, I get data from DB, and i need to create another column in grid with de sum of column1 and 2.

view Razor:

@model List<Project.Models.VW_VisitasPorNumeroVisitas>

@{
    ViewBag.Title = "Index";
}



<h2>Visitas por Numero de Visitas</h2>

@(Html.Telerik().Grid(Model)
        .Name("RadGrid1")
        .Sortable()
        .Filterable()
        .Pageable()
        .Footer(true)
        .NoRecordsTemplate("No hay registros")
        .Columns(columns =>
        {
            columns.Bound(o => o.NumVisitas)
                .Title("Numero de Visitas")
                .Aggregate(agg => agg.Sum())
                .FooterTemplate(@<text> Visitas Totales: <span >@item.Sum</span> </text>);
            columns.Bound(o => o.TotalVisitas)
                .Title("Cantidad de Visitas");

            columns.Bound(o => o.NumVisitas)
                .Title("% Visitas");
        })
)

CS:

public ActionResult Index()
{
    var visitasPorNum = from a in db.VW_VisitasPorNumeroVisitas
                        select a;

    return View(visitasPorNum.ToList());
}

[Tsvetina]

Hello Eloy,

You could consider using the GridCalculatedColumn in order to achieve your goal. It allows making some operations with a list of fields from the grid datasource and display the result. See a demo here:
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/calculatedcolumns/defaultcs.aspx

All the best,
Tsvetina
the Telerik team

[Eloy]

Thx for reply, but i want to make it in razor view, and i can't put a GridCalculatedColumn.
i see the agreggate, but i only make it for the footer section of the column.

[Tsvetina]

Hello Eloy,

It seems I missed this out - do you use an ASP.NET AJAX RadGrid or an MVC Grid? If it is the second, post your question in the MVC forums:
http://www.telerik.com/community/forums/aspnet-mvc/grid.aspx

Kind regards,
Tsvetina
the Telerik team

[Eloy]

Thx for reply, yes i don't see i'm in the ajax forum :S:S .

Sorry for the inconvenience. Thank you so much.