How to calculate totel in datatable?

[saninfo273]

following table

shrtname	KCH	KCN	KHC	KHO	KSM	KTN	KTV	Total
3-7	2		2		22		1
1-3	14	36	39	9	68	50	1
Total	16	36	41	9	90	50	2

[lrtetala (Lakshman Reddy)]

Hi @saninfo273

Please check this

How to calculate total in entire datatable?

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] Regards,

(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

Input:

Output:

Cheers!!

[ashokkarale]

@saninfo273

KCH KCN KHC KHO KSM KTN KTV Total

Use datatable expression property. e.g:

Use assign activity.

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

Thanks,
Ashok

[Parvathy (PS Parvathy)]

Hi @saninfo273

=> Read Range Workbook

Output-> dt
=> Use the 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 Workbokok dt.

Sequence10.xaml (8.3 KB)

Hope it helps!!

[Parvathy (PS Parvathy)]

Hi @saninfo273

Try this:

How to calculate totel in datatable?

Hi @saninfo273 => Read Range Workbook [image] Output-> dt => Use the 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 Workbokok dt. [image] Sequence10.xaml (8.3 KB) [image] Hope it helps!!

Regards