I have a report and have the same field (balance) across the detail band but with "print when" expressions to determine which column it should print on. Everything in the detail band works fine but the totals in the page footer are printing the SUM of the balance field in all columns,instead of respecting the "print when" expressions in the detail band.

How can I get the totals to reflect the SUM of each individual column including the "print when" statements?