Hi guys , i'm struggling with some of the basics of S92.
I'm trying to display all orders below a certain margin in a given month and year.
Not sure if i'm missing something in my layout of the calculation thats giving me the syntax error, can anyone see anything glaringly obviously wrong with my query
any guidance would be greatly appreciated
Andy
I'm trying to display all orders below a certain margin in a given month and year.
Not sure if i'm missing something in my layout of the calculation thats giving me the syntax error, can anyone see anything glaringly obviously wrong with my query
Code:
Select takenby,totlineamt, orderno, ordersuf, invoicedt, Revcost, (totlineamt - revcost) / totlineamt * 100) Margin From pub.oeeh where cono = 1 and custno= 1075 and (stagecd = 4 or stagecd = 5) and month(invoicedt) = 6 AND year(invoicedt) = 2011 AND ((totlineamt - revcost) / totlineamt * 100) <11) and (UCASE(transtype) = 'SO' or UCASE(transtype) = 'CS')
any guidance would be greatly appreciated
Andy