Need To Sum The Total Column

Hi,

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

Attached snapshot for reference.

image

Thanks,
Rishi

@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

1 Like

Thanks Anil.

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.