Compare dates for same week of current year to prior year totals
I am new to FM Pro. I have a database that has one field for the date of service. I need to create a report that will compare the totals for the month of the current yr to the prior year and list the count difference and the percent of the difference.
Ex jan 2012 Total 285 Jan 2013 Total 302 17 Difference 6 % increase
I also need to do the same calculation on a weekly report comparing the same date (which is always a Sunday) for the prior yr vs the current year.
Ex. 01/08/2012 Total 291 01/06/2013 Total 310 19 Difference 7 % increase
I also need to do the same calculation on a weekly report comparing the same date (which is always a Sunday) for the prior week vs the current week.
Ex. 01/06/2013 Total 310 01/13/2013 Total 303 7 Difference 2 % decrease
In a decreased value I would want to show this in Red.
I appreciate any help you could provide. Thank you.