I would like to get the total number of projects on which a person participated, but did not own.
Projects table has ‘project owner’ and ‘other project participants’.
Team table uses Count to get the total number of projects owned by each member. But, I am unsure how to get a total number for how many projects the team member was a participant, but not the owner.
Please share any ideas you have on this. Thank you.