To sum values in a column

Help Studio
, , , , , , , , , , , , , ,
1

Hi all,

I’m trying to add the values in a column.
The issue is that the values of column have values with commas.

For example

ColumnA
123,1
123,2

So the total value should be 246,3

I need the value with comma.

Can any one help me?

Thanks in advance!

2

Hi,

Can you try the following expression?

dt.AsEnumerable.Sum(Function(r) Int32.Parse(r("ColumnA").ToString.Split({","c})(0))).ToString+","+dt.AsEnumerable.Sum(Function(r) Int32.Parse(r("ColumnA").ToString.Split({","c})(1))).ToSTring

Regards,

1 Like
3

@Yoichi thank you so much

4

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