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