function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
ChristineVWChristineVW 

Report on Accounts with No Cases Reported in Past X Days

I'm not really sure where this question belongs so I've posted it as well in the Best Practices area.

I need to create a report that will display only those Accounts at which no Cases have been reported in the past 180 days.  My attempt so far has been to create a custom Case formula field that calculates how many days ago a case was reported drawing either from the creation date or a custom field we have in which reps can enter the reported case time: 

Now() - IF(ISNULL(Data_Time_Reported__c), CreatedDate , Data_Time_Reported__c)

And called this field Last Reported Case.

Next I created a Cases with Contacts report to show me the Min and Max value of the Last Reported Case for each Contact.  However, now there is no smart way to filter the report so that it shows me only the Accounts at which all of that Account's Contacts' Last Reported Cases have a value greater than 180. 

If I run an Accounts report, I can't report on the Min or Max values in Last Reported Case, because it is a Case custom field. 

Any ideas?