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
Number 1 net value =50,000,00000
and sum is int32 i have tried to change it to int64 also. but still same error
Does the column Number have decimal values in it? If so, can you please try changing your type to Double?
ya changed it to double and used CLng instead of Clnt
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.