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
Former Member replied

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

x:=x+qtr

x;

--Write a formula to get current year qty

numbervar y;

if date>=fromdate and date<= todate then

y:=y+qtr

y;

--Now create a variation between two

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

Thanks,

Sastry

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