Since the particulars were so complicated, I did discuss it with our consultant. He does not believe the formulas will work. He thinks the only way to get a report like I need is to use prior year data from backups. It's not an ideal workaround because the comparisons are not identical.

Perhaps this can be considered for the next JC upgrade????