I see. So what you posted was one large formula? I thought you had just copied and posted a bunch of formulas into a single post.

Here is what I'm thinking: you STILL need to create individual formulas for each output field. You can do all the calculations necessary in one huge formula like you posted, but you can't print them out that way. A formula is restricted to just returning a single value. The last variable used in a formula is what gets displayed on a report. So you'll need a formula like this:

Global NumberVar BlackActTotal;
BlackActTotal;

and then a formula like this:

Global NumberVar BlackEstTotal;
BlackEstTotal;

and so on.... Then drag and drop each of these formulas in your footer.

They are all seperate formulas... one for each color