Datatable.compute not working

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)




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

The string conditions to be enclosed in single quotes.

2 Likes

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.