AnsweredAssumed Answered

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

Question asked by AdamHorne on Feb 19, 2014
Latest reply on Feb 19, 2014 by philmodjunk

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...
      
      

Outcomes