How to calculate total in entire datatable?

Help Studio
, ,
1

This data table how to calculate total for all row.

shrtname KTN KCN KHC KCH KHO KSM KTV Total
07-Mar 14 3 13
03-Jan 15 30 23 15 47 11 34
Total 39 30 26 15 60 11 34
2

Hi @domsmgtmeet22

Try this in Assign acitivty

dt.Columns("Total").Expression = "[KTN]+[KCN]+[KHC]+[KCH]+[KHO]+[KSM]+[KTV]"

Regards

4

please fully explain it

5

how to use assign activity

6

Hi @domsmgtmeet22

Formula to write in write cell activity

=SUM(B5:H5)

image
image1362×788 63.4 KB

7

Hi @domsmgtmeet22

Can you try below

(From d In DT.AsEnumerable
 Let t = {"KTN","KCN","KHC", "KCH","KHO","KSM","KTV"}.Sum(Function (x) Convert.ToInt32("0" & d(x).toString.Trim))
 Let ra = d.ItemArray.Take(d.ItemArray.Length - 1).Concat({t}).ToArray
 Select DT.Clone.Rows.Add(ra)).CopyToDataTable

image
image900×580 29.4 KB

Regards,

8

Hi @domsmgtmeet22

=> Read Range Workbook
image
Output-> dt
=> Use below syntax in Assign:

Save to: dt

Value to Save: (From d In dt.AsEnumerable
 Let t = {"KTN","KCN","KHC", "KCH","KHO","KSM","KTV"}.Sum(Function (x) Convert.ToInt32("0" & d(x).toString.Trim))
 Let ra = d.ItemArray.Take(d.ItemArray.Length - 1).Concat({t}).ToArray
 Select DT.Clone.Rows.Add(ra)).CopyToDataTable

=> Write Range Workbook dt
image

Sequence10.xaml (8.3 KB)

image
image688×580 22.6 KB

Regards

9

solve in Datatable???

1 Like
10

Yes. @domsmgtmeet22

You can solve it in datatable.

Regards

11

Hi @domsmgtmeet22

Try this

(From d In DT.AsEnumerable
 Let t = {"KTN","KCN","KHC", "KCH","KHO","KSM","KTV"}.Sum(Function (x) Convert.ToInt32("0" & d(x).toString.Trim))
 Let ra = d.ItemArray.Take(d.ItemArray.Length - 1).Concat({t}).ToArray
 Select DT.Clone.Rows.Add(ra)).CopyToDataTable

image
image900×580 23.1 KB

Input:

image

Output:

image
image974×293 5.35 KB

Cheers!!