SAP B1 Question

[former_member688017]

SELECT (($[$38.21.0]-$[$38.U_ExtCost.NUMBER])/$[$38.U_ExtCost.NUMBER])

This is a formatted search which continues to error out:

1). [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value '$ 550.00' to data type int.

The 550 is $[$38.21.0]

[kothandaraman_nagarajan]

Hi,

Try this query,

SELECT (($[$38.21.Number]-$[$38.U_ExtCost.NUMBER])/$[$38.U_ExtCost.NUMBER])

Regards,

Nagarajan