Print this page

How do I create a report on the number of Cases opened and closed in the same month?

Knowledge Article Number 000003446
Description How do I create a report that shows the number of Cases opened and closed in the same month?
Resolution

Create a new formula field (checkbox) on the case object with the following example formula:

IF(YEAR( DATEVALUE(CreatedDate))  <>  YEAR(DATEVALUE(ClosedDate)), false, IF(MONTH(DATEVALUE(CreatedDate))  =  MONTH(DATEVALUE(ClosedDate)), true, false))

Then create a case report with the filters you need and then summarize the new formula field to count the number of cases opened and closed on the same month.


Please note that would not be according to the best practices to use a formula field as a filter of your report.





promote demote