Problems to concatenate 2 fields into a calc. and getting a summary on the calc field.
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:
and only a Qty of "1" for each item.
My calculation field is:
Which results in:
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:
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...