# FM - Adding Percent Increase to a Report

Attached see a FM report.  I want to have a column to the right of amount to show % increase/decrease from the prior year (each row is a fiscal year).  I can do this (and have done this) easily by creating a bunch of fields, but is there a way to create one field that will calculate per each row in a report?  I've been successful doing this with count and total fields via a report, but can't quite figure out how to do this with a calc field.  Thanks.
-PerIncrease.JPG
Will Loving

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, typo there. The calculated date should obviously be "11/30/05" not "1/30/05". You may also need other predicates in the relationship to find the correct record you want to relate to but that shouldn't be too hard.
Randy - Attached is a file which does the trick. It even takes into account Leap Year when the last day of Feb is the 29th rather than the 28th. Here's the date calculation the accommodates either the current or previous year being leap year:

PreviousEndOfMonth =
Date( Month( MonthEndDate ) ;
Case( Month( MonthEndDate ) = 2 ; Case( Mod( Year( MonthEndDate ) - 1 ; 4 ) = 0 ; 29 ; 28 ) ; Day( MonthEndDate ) ) ;
Year( MonthEndDate ) - 1 )

There's another way to calculate the last day of any month but in this case because you're relating year to year, either of which could be a leap year, this is better.
Prev-Year-Compare.fp7

Will, it worked!  99% of the way there, but may negative numbers don't look right.  None of them ever get over -100%.  Do I need to take the absolute value when I subtract below?:

(BldgEscs_Active::Amount - BldgEscs_PriorYr::Amount) / BldgEscs_PriorYr::Amount