I have a table that shows General Ledger ending balances for each period of the year. Each line is listed by the Year as in the following example.
2010 ClosingBalancePeriod1 ClosingBalancePeriod2 ClosingBalancePeriod3 etc
2011 ClosingBalancePeriod1 ClosingBalancePeriod2 ClosingBalancePeriod3 etc
I would like to be able to display not only the current year and period of my choosing but the previous year and period for comparison.
I have the year and month set up as a parameter but want it to display the current year and balance along with the previous year and balance depending on the year and month I chose in the parameter
For example: I choose 2011 as the year and April as the month then my formula would read:
if {?Month} = "4" then
What do I add to the formula to also show the same information for the previous year and month?