HELLO EXPERTS AS PER MY CLIENT REQUIREMENT THE FMS QUERY WAS WAS DEVELOPED TO SHOW THE MARGIN IN ROW LEVEL BEFORE ADDING THE DOCUMENT select (($[pdn1.u_mrp]-$[pdn1.priceafvat])/$[pdn1.u_mrp])*100
while executing the query the following error is appearing in the screen
1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '-'. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'Blanket Agreement' (OOAT) (s) could not be prepared.
PLEASE PROVIDE THE SOLUTION FOR QUERY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.