Hi Everyone, I am trying to do a count of r...

(Tim Watts) #1

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])))

(Aleksi Alkio) #2

Is your “Training assessment” table a child table for the parent (Clubs)?

(Tim Watts) #3

@Aleksi_Alkio its is

(Aleksi Alkio) #4

Try something like… COUNT(SELECT([Related Training Assessments][KeyColumn],[Assessment completed?]=TRUE))