Our Training Programs

All contents are copyright of their authors.

Invalid usage of aggregate function Sum() and Type: String.

Invalid usage of aggregate function Sum() and Type: String.

mohammed shamsheer

12yAsked Nov 22, 2013, 4:25 AM13.2k.NET

ds.Tables[0].Compute("Sum(Debit)", "AccGroupName='Accounts'");

Ds have

AccGroupName : Accounts,Bank,Salary etc

LedgerName

Debit

Credit

showing the error : Invalid usage of aggregate function Sum() and Type: String.

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

mohammed shamsheer11y ago
thank u for valuable solution...
Hesham Khedr11y ago
What is "Debit" column data type !!!?

var result = yourDataTable.AsEnumerable().Sum(x => Convert.ToInt32(x["Debit"]));

you can change "Convert.ToInt32()" method whatever your column data type.

Goodluck :)
mohammed shamsheer12y ago
Showing the error i tried this also but it showing error my one is double not interger i convert into int64 Syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier
Sanjeeb Lenka12y ago
try this:

it may work

ds.Tables[0].Compute("Sum(Convert.ToInt32(Debit))", "AccGroupName='Accounts'");