Input Error Add Data Row

Help Studio
, ,
1

image
image1864×849 153 KB

Hi,

Not sure to why I am getting this error with this statement.

2

Have a look if any value form the column which is used for the sum is null, empty or has a invalid format e.g 1.212,45

You can also try following
dtData.AsEnumerable.Sum(Function (a) Convert.ToDouble(“0” & a(“Total Amount”).toString.Trim)

3

image
image1726×719 142 KB

Still giving the same error

4

Had you also checked for empty, " ", Null or invalid format values for this column values?

5

Yeah all the values are valid

6

how did you checked?

7

image

Values are valid

8

logging can hide some details

  • set a breakpoint on relevant location
  • use immediate panel
  • run analysis linq

grafik

in your case:
dtData.AsEnumerable.Where(Function (x) Not Double.TryParse(x(“Total Amount”).toString.Trim, nothing)).ToList

9

After the LINQ expression put .Tostring

It is saying incorrect incorrect string. It means you need print this value as a string