If you have Admins in another table you could roll up the number of admins and then use that field to filter the report. If it is in the same table or there is no relationship, you can use a Formula Summary Query like:
Size(GetFieldValues(GetRecords("{11.EX.'" & [UserName] &"'}AND{20.EX.1}","br6abcde"),3))
(Where 11 is the User and 12 is the admin checkbox field)
Feel free to reach out privately if you want more specific help.
------------------------------
Tammie King
------------------------------
Thanks so much for getting back to me, Tammie.
Yes it is in the same table, like this:
Here's the formula I used:
Size(GetFieldValues(GetRecords("{6.EX.'" & [UserPrincipalName] &"'}AND{13.EX.1}","bs26ababa"),13))
(Where 6 is the UserName field and 13 is the Admin selection checkbox.)
In the table above, user TEST.TEST@TEST.COM is a user in both store 962 and 963. I need to count how many records with the UserPrincipalName TEST.TEST@TEST.COM have the CTID Admin checkbox checked. So essentially, both records in this grid edit should have a value of "1" in the # of CTID Admin Selected field, but only the checked record is getting it.
Hope that makes sense.
Kim
