SQLite does not support Sum on decimal

TheAxelander / OpenBudgeteer

OpenBudgeteer is a budgeting app based on the Bucket Budgeting Principle

https://theaxelander.github.io

MIT License

788 stars 43 forks source link

SQLite does not support Sum on decimal #57

Closed Christoph-Wagner closed 2 years ago

Christoph-Wagner commented 2 years ago

v1.4 in Debug mode, Windows, SQLite DB

Start app with SQLite, go to Reports.

System.NotSupportedException in ReportViewModel.cs Line 201 SQLite cannot apply aggregate operator 'Sum' on expressions of type 'decimal'. Convert the values to a supported type, or use LINQ to Objects to aggregate the results on the client side.

TheAxelander commented 2 years ago

Can confirm this. Will look into it.

TheAxelander commented 2 years ago

Should be resolved as part of #58