Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

year and prior year

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?

Former Member
Former Member replied

what is you select statement doing.

If you are filtering on Year = 2011 then you will never see prior year data.

Ian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question