AnsweredAssumed Answered

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

Question asked by binu.alexander on Jun 20, 2015
Latest reply on Jun 21, 2015 by wimdecorte

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

Outcomes