How to add integer value while the comma inbetween that (Ex. 16,000)

[ppr (Peter Preuss)]

using the immediate panel we can prototype and check our statements.
Refering to the screenshots we do see, that the statement is valid.

Now we can check for the values, which are not parseable

Similar to the example, done with a list we can do it with datatables

• set a brekapoint
• debug and get paused
• open immediate panel
  use the statement:
  DTPlant.AsEnumerable.Where(Function (x) Not Double.TryParse(x(“Good Parts”).toString)).toList

we will get back a list of datarows with all rows where Good Parts Values was not parseable.

Kindly note:

@Rajiduraikannu_Santhosh_G

{DTPlant.AsEnumerable.Sum(Function(x) Convert.ToInt32(Double.Parse(“Good Parts”).ToString)).ToString}

the reference to the looped row is missing Double.Parse("Good…
vs.
Double.Parse(x("Good…

so it was parsing the string value “Good Parts” and for sure this is not a valid value