Expression to Count ACTIVITIES that Match USEREMAIL

Hi,
I have an ACTIVITY table and I’m trying count the number of activities that’s associated with USEREMAIL(). I keep getting a list of numbers but I’m looking for a single value. Anyone help with what’s wrong with the below expression? Thanks

COUNT(SELECT(ACTIVITY DATA[ACTIVITY], [EMAIL] = USEREMAIL() ) )

My result is a list like 5, 5, 5, 5, 5, 5, 5, 5,

The result should be a 5.

Let me know what I’m missing in the expression to single out the number.
Thanks

The expression is fine. Please provide a screenshot of the configuration in which you’re using it.

Hi Steve,
Here is the result on my app:
Screen Shot 2020-07-02 at 8.46.10 AM

Here is the expression used in the Virtual Column on my Summary Table related to the above:


This is the expression I used in my Virtual Column on the ACTIVITY DATA table

Here is the expression used in the ACTIVITY DATA table:

1 Like

I’ve fixed my problem! Just enter this expression directly into the Summary table:
COUNT(SELECT(ACTIVITY DATA[ACTIVITY], [EMAIL] = USEREMAIL() ) )

I didn’t need this formula ACTIVITY DATA[NUMBER OF ACTIVITIES COMPLETED]. This produced this list, but if I just entered the formulation COUNT, etc, etc. I got the result i’m looking for.

Thanks

2 Likes