Overflow error while calculating

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(“Number”).ToString.Equals(row(“Number”).ToString)).Sum(Function® 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.