How calculate each item in excel

[Sudharsan_Ka]

HI @Anand_Designer

Checkout this thread

UiPath - Datatables, How to use GroupBy with SUM and COUNT functions

UiPath | LINQ Sum Function | Group Sum LINQ | Get Column Sum | Get Group Sum of Column with LINQ

How to use group by and get sum?

Yes. you should use assign activity. In the left hand side of assign acitivity you should use dt2, in the right hand side you should use Linq. Also see below updated linq: (From row in dt1.AsEnumerable Group row by sc = row(“STORE CODE”).ToString() Into grp = Group Let total= grp.sum(Function (x) Convert.ToDouble(x(“CREDIT”).ToString().Replace(“$”,“”).Trim())) Let result = New-Object() {grp(0)(“STORE CODE”),total} Select dt2.rows.add(result)).CopyToDataTable I missed keyword called Into…

Regards
Sudharsan