Is that on a single table? (straight table does not take expressios, does it?)
1st I use variables. Then I place the variable everywhere I need it. Changes are easier.
2nd Use functions like Margin = sum(Net Sales) - sum(Net Costs) (Use help. Type Functions. Search)
3rd Avoid using the word 'Total' as a field, it is a reserved word
I guess lengthy refers to time. Calculatios are fast. Printing is slow. How many records per year? Well, limitate the table to a year or to a month. Open the Table Properties. Tab General. Calculating Condition: count(distinct Year) = 1 and count(distinct Month) = 1. Please, filter a Year and a Month in the Calculating Condition Message.
You´ll get more tips...