- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
I presume Client Status and Client Type are fields on your Company custom form?
If so, I suggest starting over on your filter. In the Report filter builder, just build it a normal filter for those two rules and don't worry about the rule for project budgets.
Once you've used the Report filter builder to create a basic filter (Client Status = Active AND Client Type = Agency), switch the filter over to text mode. This will show you how those rules are built in text mode and you will see the issue is with your filter modifier lines (_Mod=)
It will probably look something like this:
DE:Client Status=Active DE:Client Status_Mod=in DE:Client Type=Agency DE:Client Type=eq
From here, you can append the additional lines for the EXISTS filter and save.
I will also mention that for a report like this, you might consider just making a project report where budget is not equal to 0, status is active, company:Client Status is Active, and company:Client Type is Agency. Then, group your report by Company name and make the Summary tab your default tab. This will show you not just a list of companies that have active projects with budget, but will also show you a count of how many projects for each company.
Good luck!
Views
Replies
Total Likes