combine two line items


I have two line items that are addressed to the same list but each one stores a value. that is, in lineitem1 there are some countries in lineitem2 there are countries that do not appear in lineitem1. I need to combine lineitem1 and lineitem 2 into lineitem3. How can this be done?

Best Answer

  • rob_marshall



    So, if I am understanding you correctly, which I am not sure of, your formula on Region Def would be:


    if isblank(By Region) then 'R1 - Region' else By Region