I am trying to calculate the % change from one year to the next and it just isn't working. Can someone else look at this and tell me what I'm missing?  My report looks something like this:

Current Assets         Last Year        This Year
   Cash on Hand          $$$$                $$$$


Cash on Hand is in GH3.

I want to calculate the % of change from one year to the next. This is my formula:

((Sum ({@Last Year}, {FLP003.REP5})-Sum ({@This Year}, {FLP003.REP5}))/Sum ({@Last Year}, {FLP003.REP5}))*100

I have checked multiple times and I am selecting the correct group summary (Group #3). Any suggestions? My formula keeps returning the same value for every group. The only other problem that I can see is that maybe the report is confused by the fact that I have the report grouped 3 ways on the same field? Even so, I am certain that I'm selecting Group#3: FLP003.RE05 - A: Sum of @This Year and Group #3: FLP003.RE05 - A: Sum of @Last Year for my calculations.

Yes...Last Year and This Year are formulas. One of the formulas:

if {FLP004.PSTPER} = {?Last Year Posting Period} then {FLP004.CYCR04}+{FLP004.CYDR04}

When I look at the % being displayed with the formula above, it's the % calculation for the summary in GF1. This percentage is being displayed on every row of GH3. I'm not sure if I'm explaining that clearly, but here's what it looks like:

Current Assets         Last Year        This Year        % Chg
   Cash on Hand          $$$$                $$$$            -7.11%
   CD                            $$$$                $$$$            -7.11%
   Accounts Rec            $$$$                $$$$            -7.11%

-7.11% is the actual correct % for GF1 (or Total Assets).

Is {FLP003.REP5} the field you're grouping on in Group3? If not, you need to change it to match the field for Group3.

-Dell