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! Go to Solution.
Try:
count(select([Related Trainees][_ROWNUMBER], ([current status]=“Active Approved”)))
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |