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

    Individual count of data in a multivalued field using portals.


      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.