Hi,
I’m trying to sum all values of a colums using: *
BUS_Datatable_test.Compute(“SUM(Columnname)”, “”).ToString
got this: Assign : Syntax error in aggregate argument: Expecting a single column argument with possible ‘Child’ qualifier.
Hi,
I’m trying to sum all values of a colums using: *
BUS_Datatable_test.Compute(“SUM(Columnname)”, “”).ToString
got this: Assign : Syntax error in aggregate argument: Expecting a single column argument with possible ‘Child’ qualifier.
@abdel use this
BUS_Datatable_test.AsEnumerable.Sum(Function(x) If(IsNumeric(x(“Columnname”).ToString.Trim),CDbl(x(“Columnname”).ToString.Trim),0))
hi @abdel
you can check it with this
Convert.ToInt32(BUS_Datatable_test.Compute(“Sum(“Column Name”)”, “[“Column Name”] > 0”));
Thanks
Ashwin S
there is a validation error.
constante name must contain one caractetr
Hi @abdel
Check this linq query
BUS_Datatable_test…AsEnumerable().Sum(x=>x.Field(“SomeProperty”));
Thanks
Ashwin S
can’t find ASenumerable as methodes. for dt.
hI @abdel
BUS_Datatable_test.AsEnumerable().Sum(x=>x.Field(“SomeProperty”));
previously it was with 3 dots
Now you check
Thanks
Ashwin S