Need To Sum The Total Column

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Hi,

I need to calculate the sum of “AGE” column and write it in to beside total column.

Attached snapshot for reference.

Thanks,
Rishi

[ppr (Peter Preuss)]

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints P…

[Anil_G (Anil Gorthi)]

@Putta_Sri_Sai_Rishik_Chow

Please try this

Dt.AsEnumerable.Sum(function(x) cdbl(x("Age").ToString))

Or

dt.Compute("Sum(Age)", "") - this returns an object

Cheers

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Thanks Anil.

Dt.AsEnumerable.Sum(function(x) If(x(“Age”).ToString.IsNumeric,cdbl(x(“Age”).ToString),0))