Specified cast is not valid - when trying to retusn sum

Help Studio
1

I am trying to return sum of column “BROJ APLIKACIJA” from data table (all is printed well after extracting from excel)

image

but getting error “Specified cast is not valid”

I’m using
tabelaPlasiraniTotal.AsEnumerable().Sum(Function(r) r.Field(Of Double)(“BROJ APLIKACIJA”)).ToString

2

Hi @Olivera_Kalinic

Try this expression

(From d in dtData.AsEnumerable Where Not (isNothing(d("BROJ APLIKACIJA")) OrElse String.IsNullorEmpty(d("BROJ APLIKACIJA").toString.Trim)) Select v = CDbl(d("BROJ APLIKACIJA").toString.Trim)).Sum(Function (x) x)

Regards
Gokul

1 Like
3

DT.Asenumerable.sum(Function(r) CInt(“0”+r(1).Tostring))

1 Like
4

I tryed, but getting the error below

image
image694×329 76 KB

5

This one also returns error

image

6

DT.Asenumerable.sum(Function(r) CInt(“0”+r(1).Tostring)).Tostring

7

Try with this expression

(From d in dtData.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).Sum(Function (x) x)

d(1) → Is the column index

Regards
Gokul

8

Thank you for your support, in the meanwhile I find solution by iterating through all table rows and making sum of wanted column items.