One column shows the difference in dollars (since the previous columns are in dollars).

 

The second column shows the difference as a percent.

My calculation works great for the Percent column, however the column is formated as currency.

 

If I change the format of the percent column to be a percent, all of the other columns in my cross-tab also change to a percent. It seems that it is either an all or nothing situation.

 

Can anyone point me in the right direction?

 

Thanks.