Hi Everyone,
I am trying to do a count of records and I’m am getting now where.
I have a page called “Clubs” and a page called “training assessment”
On the clubs page, I want to do a virtual column that counts of all of the "training assessment"s that have been completed by staff at each Club. I have tried a heap of different formulas and can’t make it work.
Count(select(training assessment[club],and([Assessment completed?]=”True”,[club]=[_thisrow].[club name and code])))
count(select(training assessment[club],and([Assessment completed?]=”True”,[club]=[_thisrow])))
Is your “Training assessment” table a child table for the parent (Clubs)?
@Aleksi_Alkio its is
Try something like… COUNT(SELECT([Related Training Assessments][KeyColumn],[Assessment completed?]=TRUE))
User | Count |
---|---|
42 | |
28 | |
24 | |
24 | |
13 |