AnsweredAssumed Answered

Compare dates for same week of current year to prior year totals

Question asked by JohnPiscopo on Sep 11, 2013
Latest reply on Sep 13, 2013 by philmodjunk

Title

Compare dates for same week of current year to prior year totals

Post

     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.

Outcomes