Jump to content

jobarb

Members
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jobarb

  • Rank
    Newbie
  1. jobarb

    Better Sql Statement

    Thank you for our reply, Sorry for the long delay in responding, this covit thing ..... What i am trying to accomplish is a gross profit report based on sale items sold for a given period Kind Regards Jo
  2. Hi. I am new to this forum . I have the following sql select statement select SUM(QTY), DESCRIPTION, PRICE ,SALESTAX,COSTPRICE, SUM(QTY*PRICE) as subtotal, SUM(QTY*PRICE) * SALESTAX / (SALESTAX+100) as vat, SUM(QTY*PRICE) - SUM(QTY*PRICE) * SALESTAX / (SALESTAX+100) as SELLINGPRICEEXVAT , SUM(QTY*COSTPRICE) as totalcost, round(((SUM(QTY*PRICE))- (SUM(QTY*PRICE) * SALESTAX / (SALESTAX+100)) - SUM(QTY*COSTPRICE)),2) as GP, ((((SUM(QTY*PRICE))- SUM(QTY*PRICE) * SALESTAX / (SALESTAX+100)) - SUM(QTY*COSTPRICE)) / (SUM(QTY*PRICE)- SUM(QTY*PRICE)
×
×
  • Create New...