How to show calculated field in the index view?

Dear Suthish Nair,

It is not that I do not know how to write the query to get the desired result, here is the query which works absolutely well:

var invoice = db.tblInvoices

.GroupBy(x => x.fldCaseId)

.Select(g => new { fldCaseId = g.Key, Amount = g.Sum(s => s.fldAmount) });

The problem is I am not able to pass it on to the view through the associated ViewModel so that I get the Amount against each appended row in the index view.

Please help.

Arun Khatri10y ago

Thanks!

Suthish Nair10y ago

Use Group By on Caseid or CaseNo. Do not wait for ready made answers, try yourself, which helps you to learn.