How to Add all amount in data table

[copy_writes (chethan)]

hello uipath comunity

here I want to add all the data in the data table how to do that

hear I want to add all amount And want to write it in front of the total amount how to do that can anyone help me to solve this I hope I will get a replay

Thanks
Chethan

[AkshaySandhu (AkshaySingh Sandhu)]

Hello @copy_writes
try this

dt.Compute("SUM(Amount)", "").ToString

[copy_writes (chethan)]

@AkshaySandhu

dt.Compute(“SUM(Amount)”, “”).ToString

sorry i didn’t get this would you please explain I want to add all the amount what u saw in the screenshot

[copy_writes (chethan)]

i get this error when am using i try in different way but i am not get the solution

[AkshaySandhu (AkshaySingh Sandhu)]

you need to pass the column name in that expression…
like in your case it would be like
InvoiceOP.Compute("SUM(Amount)","").ToString

[copy_writes (chethan)]

@AkshaySandhu

InvoiceOP.Compute(“SUM(Amount)”,“”).ToString

i get this error when i use that condition

[copy_writes (chethan)]

I use this bellow i get the output

InvoiceOP.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“Amount”).ToString.Trim) ).ToString