AnsweredAssumed Answered

Individual count of data in a multivalued field using portals.

Question asked by Jmthewhite69 on Jan 16, 2017
Latest reply on Jan 31, 2017 by Jmthewhite69

Hello community.


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:


équip1= 1

équip2= 2

équip3= 2

équip4= 1


I did a lot of tests with the count function without any luck.


Thanks in advance.