I have a dilemma. I have 2 sets of users (main and region). Main users (10 of them) show their information (ie, username, calls answered, tickets, opened, tickets closed, total tickets) and this is run every week. The {table.user} is already set in the formula record for only Main users.

However for the summary, I need to combine the Main Users and the Region Users (6 of them) and print out a total number of tickets opened.

Main users:
["james","kelly","tom","alfred","ashley","thomas","karla","carla","jim","don"]
Region user:
["marvin","xander","sean","mary","eric","tony"]

I have setup my formula field called all_open with the following code:

if {table.user} in["james","kelly","tom","alfred","ashley","thomas","karla","carla","jim","don","marvin","xander","sean","mary","eric","tony"] then 1 else 0

then I setup a running total OR insert summary. However, this only counts the Main users.

Is this because I hard coded {table.user} for Main Users only? If that is the case, how do I show on the report only Main Users information, but at the same time count total tickets between the 2 sets in the summary?

Thanks!

You are correct on "limited values" in table.user.

You are a gentleman and a scholar!