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 Employee replied
Hi Daniela Firmino
This can be done using group :
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 ..
if date>=dateadd('y',-1 fromdate) and date<=dateadd('y',-1 todate) then
--Write a formula to get current year qty
if date>=fromdate and date<= todate then
--Now create a variation between two
Place all fromulas on your group footer and suppress detail line.