I'm attempting to write the formula for a computed column in SQL Server 2005 using SQL Server Management Studio 2008. I get the error validating formula and I'm not sure how to write the formula to work.

If it were standard math the formula would be:

(mmtot * 22) + (mattot * 2) + odctot

mmtot, mattot, and odctot are also computed columns so that may be the problem but I'm not sure.