This is a migrated thread and some comments may be shown as answers.

Add Column with sum result of other 2 columns

4 Answers 195 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Eloy asked on 29 Mar 2012, 10:35 AM

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());

}

4 Answers, 1 is accepted

Accepted