2 Replies Latest reply on Sep 22, 2013 8:58 PM by sdonner

    list() calculation

    pjdiii

      Title

      list() calculation

      Post

      Trying to use the List() function .

      Basically :

       

      List(Fieldname)

       

      Where there are 1000 records with a field called "Fieldname"

      I assumed that to see the list it had to be a calculated field.

      So i set up a calc field called "list".

       

      I get ONE value(the value of "Fieldname" in the current record)

       

      From the help file, I thought that if "Fieldname" had the values: 1,2,3..., 999. I would get a return separated list like:

       

      1

      2

      3

      ...

      999  

       

       

      I'm either reading this wrong or entering it wrong.

       

      Ideas?

      Thanks

        • 1. Re: list() calculation
          LaRetta_1
            

          List() works on "any related field, repeating field, or set of non-repeating fields; or an expression that returns (same).

           

          So if you want a list of the values of a field in the current table, you must create another table occurrence of it and you can join using the X (cartesian operator); joining any two fields except calculations, globals or containers and they don't have to match.  This will allow ALL records to be related and will show field values from ALL records in your calculation.  Then the calculation would be (result is text):

           

          List ( yourTable selfJoin::fieldName)

           

          But this will also give you duplicate values.  Is this what you wish or do you want a unique set returned?

          • 2. Re: list() calculation
            sdonner

                 I have a similar issue where I'm trying to get a field to show a list of all the unique IDs after a find. Suggestions?! Thanks!