If
dt
is a
Data.DataTable
object, you can use something like that:
var values = dt.AsEnumerable();
int total = values.Sum(r=>r.Field<int32>("myVal"));
var PercSum = from v in values
select new
{
Value = v.Field<int32>("myVal"),
SumOfValue = total,
Percentage = Convert.ToDecimal(v.Field<int32>("myVal")) / Convert.ToDecimal(total)
};
Console.WriteLine("Value | Sum | Percentage");
foreach (var p in PercSum )
{
Console.WriteLine("{0} | {1} | {2}", p.Value.ToString(), p.SumOfValue.ToString(),p.Percentage);
}