A table with a Totals column is a perfect use case for computed columns in MSSQL. Making the Totals column a computed column allows MSSQL to do all the preassigned math for me, eliminating the need to write SQL or ColdFusion code to sum up the monthly totals. Every time I update the table I would have to run other code or SQL to again obtain the correct total.
Here's my table, MonthlyPay.
By turning Totals into a computed column, my life is easier. Here's how:
ALTER TABLE [MonthlyPay] ADD [Totals] AS (
[January] + [February] + [March] + [April] + [May] + [June] + [July] + [August] + [September] + [October] + [November] + [December]) PERSISTED;
ALTER TABLE [MonthlyPay] DROP COLUMN [Totals];
I could add even more calculations including the math to get tax percentages and including those in the total. So much easier!