Solved: Expression to Count ACTIVITIES that Match USEREMAI... - Page 2

Tony_Insua · 07-02-2020 08:16 AM

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

Tony_Insua

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

View solution in original post

Expression to Count ACTIVITIES that Match USEREMAIL