1 Reply Latest reply on Feb 19, 2014 2:39 PM by philmodjunk

    Problems to concatenate 2 fields into a calc. and getting a summary on the calc field.

    AdamHorne

      Title

      Problems to concatenate 2 fields into a calc. and getting a summary on the calc field.

      Post

           Hello.

           I'm trying to create a summary field that will combine the UUID and QTY into a single line with "|" as a field seperator.   I have the following 4 UUID numbers.   I'm having a problem trying to get a Listof summary as it will only allow for a summary of one field.  I have tried to create creating a calculation that concantinates the fields together, then creating a Listof summary on the calculation, but I'm getting crazy results. 
            
           My field names are simply "id" and "QTY" . Here is the sample data I'm working with: 
            
           id
           17F6F298-78BF-4CB3-9385-AAF6F8FCEE96
           CF835234-45EE-4310-A264-74AD43E60D37
           9EA85F1A-A7D4-4E13-A3A7-26F1DB810F38
           D5E988CE-E023-487B-88F2-F6155B9D37A5
            
           and only a Qty of "1" for each item.
            
           My calculation field is: 
           Accessories::id.accessory&"|"&Accessories::qty
            
           Which results in: 
           17F6F298-78BF-4CB3-9385-AAF6F8FCEE96|1
            
           It's doing good, except it's only pulling the first record id and qty. 
            
           For the sake of curiostity, I did a Listof Summary on my calculation field and it wielded an odd result of:
            
           17F6F298-78BF-4CB3-9385-AAF6F8FCEE96|2
           002F941E-9258-4C09-AC07-92BDD9A6D27D|1
           |
           |
           |
           |
           |
           17F6F298-78BF-4CB3-9385-AAF6F8FCEE96|1
           |
           |
            
            
           I'm not really sure where I went wrong, or if what I'm trying is possible with my method.  Previously, I was putting the results into a globalvariable, which was working fine.  I'm just trying another method and I'm wondering where I went wrong, for my own sake...