Datatable.compute not working

[ChitraPal]

Hi I am trying to compute on Datatable , but its not giving expected output.

I am trying to get sum of Amount for each vendor.
I have two files. One for Vendor id’s and another for Vendor Id and Amount.

VendorID.xlsx (7.9 KB)
VendorIDwithAmount.xlsx (10.2 KB)

[ChitraPal]

[KarthikByggari]

In the compute, give like this “Vendor_Id='” + VID.ToString + “'”)

The string conditions to be enclosed in single quotes.

[prasanna.Ui (prasanna)]

Hi ,
find attached file.
I hope it may helpes you.sumOfVendor.xaml (10.8 KB)