Counting elements of a list based on a criteria

I’m trying to come up with an expression that counts the number of related trainees that have a status of “active approved”. The below expression doesn’t work because I’m not sure how to “dereference” or whatever you call it the [current status] column within the individual related trainee records. Please advise.

count(select([Related Trainees], ([current status]=“Active Approved”)))

Solved Solved
0 14 291
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Try:

count(select([Related Trainees][_ROWNUMBER], ([current status]=“Active Approved”)))

View solution in original post

14 REPLIES 14
Top Labels in this Space