Merge two line items of type list into one of same data type


Good morning,

I'm trying to merge two line items of type list into one with the same list. I have tried operators ("AND", "&", "+") and non of them seem to work. Does some one know how to do this?

Find a screenshot of what I'm trying to do:

Canal Total should be canal + canal2

Best Answers

  • Arnab116
    Answer ✓

    Hi @beatrizduenas ,

    I could see Canal, Canal 2 and Canal Total is list formatted "Canal" which indicates that the output should be the part of the list.

    1. You can't merge to list. IF you want to see a outcome where you want to see the concatenation of Canal & Canal 2 then first you need to convert them in to text format and the use "&" to concatenate and most importantly the output line item should also be text formatted.

    Canal Total (Test formatted) = NAME(Canal) & NAME(Canal 2) would work.

    Thank You,


  • SriNitya
    Answer ✓

    You cannot merge two list formatted line items, only Text formatted can be merged.