String to double,

Help Studio
, ,
1

Hi,
I have a collection of type string, which consists of integers and decimals I am trying to add them by
stringSum= listvalues.sum(Function(s) cdbl(s)),
but I am getting error–> conversion from string to type double is not valid.
How can I add them, I need sum of list.

2

Hi @Swetha_MN ,

Could you let us know what are the values in the list that you are trying to find the sum value ?

3

14,341,1.01,12,345,3,456.34

4

@Swetha_MN

I’m able to get the sum without any issue

image
image745×256 10.9 KB

Check below

Also check if your list is containing any null values or string values

Hope this may help you

Thanks

5

@Swetha_MN

Check below

image
image906×290 15.7 KB

Thanks,
Srini

6

grafik

7

You have taken only integers, my list contains decimals also ,. (14,341),(1.01),(12,345),(3,456.34)

8

grafik

9

@Swetha_MN

See here there are 14,341 which is considering as String, so you need to replace that

image
image734×300 14 KB

Hope this will help you

Thanks

10

@Swetha_MN ,

If the above suggestions still do not work, Do provide us with the Screenshot of the data used in the List by performing Debug, it seems the data has some issues.

We should be able to get the Sum even if there are decimals and whole number values in the list.

Let us know if you could provide the Screenshot of the Data in Debug Mode.

11

maybe the discussion can be short cut.

Above we do see that initial Sum and CDBL is working (assumption valid strings, not empty strings)

  • when default formats are to expect: comma is group seperator, dot is decimal seperator
    THEN we can use CDBL method

  • when a local format like dot is group seperator, comma is decimal seperator is used
    THEN we would parse it e.g. with:
    Double.Parse(TheNumberString, System.Globlaization.CultureInfo.CreateSpecificCulture(“de-DE”)) or other culture matching the format

12

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