Thank you, but that did not help. I still get 3.00 as the result.

As for your question of turning SQL Server into a calculator: the application generates a large formula and substitutes values into the string, so I then need to perform the calculations using the actual variables.