No replies yet. Must be someone out there that has come across this need.
On the calculate event for the field you could do something like
don't include the equal sign though.
It seems that will only work with text fields. I have 98 numeric fields that I would need to change, and then I'm summing all of the expenses for each day at the bottom of each column. Each column total is derived with this formula: sum (Table_Exp.Row1[*].Amount1). If I change all of the numeric fields to text fields, I would then need to find out how to convert the values back to numeric to allow for the formulas to work.