0

I created a report that shows Users with Activities from this week. It groups records by Full Name and for Users with Activities, it shows a correct number of records. For Users without Activities, it shows record count (1) instead of (0). Is it possible to fix it? The report is created from custom report type (Users with or without related records from Activities (Assigned To)) without any customizations except date range.

example

0

It's because your custom report type basically says "with or without" the child record. So the parent records are always shown, whether or not they have child records.

I haven't tried this, but I think you might be able to filter out users without activity by the blank Subject column.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.