I am trying to get a query to perform some math on some user fields so that this query could be made a formatted search for another user field ... all in the BOM.
DECLARE @X1 AS REAL
SET @X1 = $\[$3.U_PartLength\] * $\[$3.U_PartWidth\]
SELECT $\[$3.U_PartLength\], @X1
This code produces an error near "$3.U_PartLength"
The user fields are defined as "Units and Amounts" and "Quantity"
The reason I don't include the calculation in the SELECT statement is that this is the beginning of a complex series of calculations after which I will have to choose the lesser of two values.