Skip to Content

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

Comparison Report

I have to create a report that compares (side-to-side) data from this year and last year. The data is located in only one table and I have to create three more formula fields to calculate the variance. Any ideas?

Former Member

Hi Daniela Firmino

This can be done using group :

Example :

If your table contains : part, qty,date fields then

--Create a group on Part

--create a Date Parameter to get from date and to date

--Write a formula to get last year the qty like ..

numbervar x;

if date>=dateadd('y',-1 fromdate) and date<=dateadd('y',-1 todate) then



--Write a formula to get current year qty

numbervar y;

if date>=fromdate and date<= todate then



--Now create a variation between two

Place all fromulas on your group footer and suppress detail line.



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