12 Replies Latest reply on Jan 31, 2017 6:28 PM by Jmthewhite69

    Individual count of data in a multivalued field using portals.

    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.