How to find the difference in values on a single field in reports?

I have been struggling to get to make a formula that will count the difference in a single field.

For example, I want to count the difference of inbound tickets between this week and last week in a single report.

I was able to easily enough get two weeks of data with filters but found it problematic trying to get the difference between the two.

I used a stock formula from SF and decided to attribute a -1 value to this week and a +1 value to last week.

The count worked as a sum and did exactly what I hoped for which I was not able to achieve through Summary Formula.

I hope this helps someone in the future as I struggled to find anything like this.

IF (    CEILING(        (DATEVALUE(CREATED_DATEONLY) - DATE(YEAR(DATEVALUE(CREATED_DATEONLY)), 1, 1) + 1) / 7    ) = CEILING(        (DATEVALUE(NOW()) - DATE(YEAR(DATEVALUE(NOW())), 1, 1) + 1) / 7    ),    -1,    +1)

#Reports & Dashboards  #Report  #Reports  #Reporting