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 )

 

Ex:

 

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.

Attachments

Outcomes