I'm not sure why, but this expression seems to return the count of all related rows when what I want is to return the count of all related rows where "White Bread" is the selected option in an enumlist field called "bread".
Count(
Select(
[Related Food Orders][Row ID],
In("White Bread", [Related Food Orders][Bread])
)
)
Never mind, I figured it out:
Count(
Select(
[Related Food Orders][Bread],
In("White Bread", [Bread])
)
)
Nice to know you got it working. Sorry that I did not see your latest post before posting my response.
You could try this
Count(
Select(
[Related Food Orders][Child Table Key],
[Bread]="White Bread"
)
)
I believe the child table is "Food Orders" , please substitute key of the table "Food Orders" in the [Child Table Key] in the expression above.
User | Count |
---|---|
17 | |
7 | |
6 | |
5 | |
3 |