Overflow error while calculating

Help Activities
, , ,
1

Dear Team,

M using below syntax, however getting error " Arithmetic operation resulted in an overflow".
in Assign Activity –
SUM = dt_sourcefile.AsEnumerable().Where(Function(r) r(“Number”).ToString.Equals(row(“Number”).ToString)).Sum(Function(r) CInt(r(“Net Value”)))

please help what i need to change

2

Number 1 net value =50,000,00000
and sum is int32 i have tried to change it to int64 also. but still same error

3

Does the column Number have decimal values in it? If so, can you please try changing your type to Double?

4

ya changed it to double and used CLng instead of Clnt

5

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