dimanche 14 juin 2015

Sqlite incorrect sum with filter

String query = "SELECT * , SUM((price)-((price* TAX)/100+purchaseprice)) as'"+KEY_PROFIT+"', SUM(price)* tax/100 as'"+KEY_TAXMAX+"' FROM salesTable where timeStamp BETWEEN '"+startdate+"' AND '"+enddate+"'"; Cursor c = dbSales.rawQuery(query, null); if (c !=null) { c.moveToFirst(); } return c;}

I always get a slightly wrong result.

Aucun commentaire:

Enregistrer un commentaire