Can anyone see why this would be returning this error?
Is it possible that your ForeQty is an integer and not a decimal? Then you might need to use IntToString.
Not it, I don’t think. I did the same thing and got a
“Syntax is OK” message
the data type of this field is nvarchar, and the convert is to varchar. Try place an n in front of the datatype that you are trying to convert to??
convert (nvarchar, Forecast.ForeQty)
May need the full SQL to troubleshoot it. The error may not necessarily be in that one.
I agree with Pedro. See if you get the error in the Analyze tab before adding the calculated fields.
just started a new baq from scratch to not get the error message 