5 Replies Latest reply on Sep 5, 2018 1:44 AM by meenu choudhary

    String Concatenate with null

    fangfang.guo.0

      Hello,

      I have created a calculated field based on concatenation of a few field,

      IIF([A] = 'NotFound','A','')+IIF([B] = 'NotFound','B',''). The result supposed to be either A, B, AB, or null. While new field is always null.

      I tried to changed it in someway below,

      IFNULL(IIF([A] = 'NotFound','A',''),"")+IFNULL(IIF([B] = 'NotFound','B',''),"") still return null for all values.

       

      Is there a way I can change this to where if a value not found but the end result not affected?