9 Replies Latest reply: Jan 4, 2014 2:23 PM by Stefan Fischer RSS

    Concatenate formulas

    Stefan Fischer

      Hi,

       

      how  can i concatenate to formulas? First I have if terms, that retrieve value1 without Null. Additional the second value2 should be ingegrated after if()...

       

      =aggr(concat(if(value1='NULL','',value1)), name)

      +

      value2 = { $(=if (vVariable = 1,'a','b'))}

       

      Regards

      Stefan