I think/hope this is a simple question.

 

In my report I use a table that contains the following fields:

- Companies.SalesManager

- Companies.UniquedID

- Companies.StateChange

- Companies.State

 

What I am trying to do is to make an overview per sales Manager of the companies he/she is responsible for that:

1- have the State 'contacted'

2- have a StateChange that is in last 30 days

 

What I started to do is just group by sales Manager, but then I got lost as the count function does not seem to allow for multiple arguments.

 

Help on this would be greatly appreciated!

 

If {Companies.State} = 'Contacted' or {Companies.StateChange} >= CurrentDate - 30 then 1 else 0

 

You would then SUM this formula to get the count you're looking for.