1 2 Previous Next 22 Replies Latest reply on Jun 21, 2015 4:36 AM by wimdecorte

    Can I Create a unique value Set  In a subsummary field ?

    binu.alexander

      In Python I use

       

      # Create a set from this list.

      # ... Duplicates are ignored.

       

      Input

      numbers = set([10, 20, 20, 30, 40, 50])

      print(numbers)

       

      Output

       

      {40, 10, 20, 50, 30}

       

      Is there a Filemaker alternative for this   to  generate  a  unique (set of values ) in a field  on a subsummary report ?

       

      eg.    field  A   in record 1 has the values   1,3,5,7

               field A   in record 2  has the values   2,4,6,7

       

      Summary repot sorted by field A should return the  set  ( 1,2,3,4,5,6,7)   ignoring duplicates

       

      This would be really useful in an application I am developing

        1 2 Previous Next