Hi All,
Maybe I am missing something very obvious, I have a name field with 3 names selected (example)
but when I do a count on that field I get 1 instead of 3.
Is there a way to do a count that gives me 3 as a result?
Hi @Remco_de_Louw 
!
Per your screenshot you have a list of names (which would count as 1 item) as illustrated by the squared brackets surrounding your names ([ … ]) and not just 3 names (3 items) …
Depending on how you get those names/your current setup, there might be multiple ways to count those names but I guess you could try to flatten the list using ListCombine(), maybe…
If this is a related column and this list of names is linked in a way or another to a relation/linked relation field, you might want to check if that field is set as multi-select… potentially
Hi! Thanks for your reply.
This is the formula that gets the data:
Organisatie.Filter(Bedrijf=thisRow.Dealer.Bedrijf).Members
The original field is also a formula : sort([Volledig Adresboek].Filter(Organisatie.Contains(thisRow)&&Conventie.Contains(Conventies.Filter(Active=true))),ascending: true)
Maybe you could try this 
…
Organisatie.Filter(Bedrijf=thisRow.Dealer.Bedrijf).Members.ListCombine()
Thanks for the suggestion, that makes it all one item as well, I got it to work but I don’t really understand why. The original column was a text field with a formula, I now made it a select list with the same formula and then it works? Weird haha.
hi @Remco_de_Louw ,
we don’t see the table, so we have no idea about the values in living in the display column, but
could you try this in which I assume that the column Dealer is the display column.
Organisatie.Filter(Bedrijf.Contains(thisRow.Bedrijf)).Members
Cheers, Christiaan
I will try this, Thanks!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.