Invoke code: Exception has been thrown by the target of an invocation / 2-digits-after-the-decimal-point

[prasath_S]

Hi @Soudios

Please try this,

dt.asenumerable.Where(function(row) not String.IsNullOrEmpty(row("Somme de Ratio").ToString)).ToList().ForEach(Sub(row) row(“Somme de Ratio”)= Math.round(cdbl(row(“Somme de Ratio”)),2))

It is similar to this one,

Skip Empty Row in DataTable

Hello, I Have this scenario. I have DT, and I want to convert the value on the specific column from string to Decimal. it’s working fine if all the row is not empty, but it went to error when some row is empty. I’m using invoke code to convert the row dt.asenumerable.tolist.foreach(sub(row) row(Col)= CDec(row(Col))) [image] Thanks,

Thanks