I am creating a system to track our members scores in horse shows. I’ve managed to create all the tables I need and have the sorting and grouping down. The last item I need on a Detail screen is to count the number of unique “shows” a member has attended. Every formula I’ve tried either gives me the count of ALL the shows I have in the shows table or it gives me an error. Here is the details page Im trying to figure this out on:
To show only the ones your member attended you have to filter the shows by member, as follows
Alternatively, you can just use
As you had already filtered by member in the Points column
I hope it helps
I KNEW it was something simple. Thank you so much for your help and time!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.