UIPATH Group by sum using LINQ

[Gashu.REMUS]

Hi Everyone,

I had tried to group and sum the datatable using LINQ. However, I got the error “Assign: Arithmetic operation resulted in an overflow.”

LINQ:
(From d in YourOriginDatatableVar.AsEnumerable
Group d by k=d(“GroupID”).toString.Trim into grp=Group
let n = String.Join(“,”,grp.Select(Function (x) x(“Value1”).toString.Trim).Distinct())
let p = String.Join(“,”,grp.Select(Function (x) x(“Value2”).toString.Trim).Distinct())
Let s=grp.Sum(Function (x) CInt(x(3).toString.Trim))
let ra = new Object(){k,n,p,s,d(“Value4”).toString}
Select dtReport.Rows.Add(ra)).CopyToDataTable

Can anyone help me?

Gashu

[Manish540 (Manish Shettigar)]

Check this below link, @Gashu.REMUS

Linq query for groupby and sum

@Sugumar8785 - pls try below - Build a datatable with same format and data → name as dtData dtResults = dtData.Clone dtResults = (From dte In dtTable.AsEnumerable Group dte By col1=dte(2).ToString.Trim Into Group Select dtResults.Rows.Add({col1, Group.Sum(Function (x) CInt(x(1).toString.Trim))})).CopyToDataTable you can get the same output Col1 – Col2 AA – 55 RT – 27 HL – 37 let me know if you find an issues…

Hope this may help you

[Gashu.REMUS]

@Manish540 Thank you for your help.

I knew why I have the error message now. It is because I need sum the value seem as 10000000000. It is out of the range. May I know is any ideas do solve this issues?

Thank!

[Gashu.REMUS]

@Linq query for groupby and sum

Group.Sum(Function (x) CInt(x(1).toString.Trim)

@Manish540
I had fixed the problem. I changed the Clnt to CDbl and fixed the problem. Thank you for your help!!!