First of all, sorry for my english. I partially used google translate.
I want to count the number of identical values of a multivalued field but i'm using portals and relationships.
Make sure you take a look at the attached file because even though I wrote my question in text, it's a bit more complicated than that.
The sample file open in the correct layout. what i'm looking for is at the bottom of the layout. ( in red )
Record 1 contains (equip1, equip2 and equip3)
Record 2 contains (equip2, equip3)
Record 3 contains (equip4)
Result following the calculation:
I did a lot of tests with the count function without any luck.
Thanks in advance.