public int GetAverageExpense() { try { using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH)) { var allExpenses = conn.Table <ExpenseItem>(); var expenses = (from r in allExpenses group r by r.Date into g select new { Amount = g.Sum((t) => (t.Amount)) } ); float avgCurrency = (float)expenses.Average(o => o.Amount) / 100.0f; int avg = DataConversion.ConvertCurrencyToCents(avgCurrency); return(avg); } } catch { return(0); // error!! } }