uipath : Datatable compute sum using complex queries

TestOutDT.Select(“振替結果 = ‘○’”).AsEnumerable.Sum(Function (x) If(Double.TryParse(x.item(“請求金額”).ToString, Nothing), Double.Parse(x.Item(“請求金額”).ToString), 0)).tostring

Sort Data table using DataView

—–SORT using dataview Dim dv As New DataView(DS.Tables(0)) dv.Sort = (“country”) ‘,city,loc,type,name” DS.Tables.Clear() DS.Tables.Add(dv.ToTable)