5 Replies Latest reply: Jan 24, 2013 6:32 AM by Malathi Subburathinam RSS

    Concatenating a table field and free text

      Hi All,

       

      I have an expression where i need to concatenate a table field and a free text. Here is an example,

       

      =if([Dim Store Attr CD] = 'OBJ_PARAM_DIAMOND', 'DIAMOND' - [Dim Store Attr Val])

       

      Here [Dim Store Attr CD] and [Dim Store Attr Val] are fields from a table and 'OBJ_PARAM_DIAMOND' is a field value and i Just want to Concatenate the free text, 'Diamond' and a hypen '-' with the field name [Dim Store Attr Val]

       

      Is it possible to do. I m not getting the expected result using above expression.

       

      Regards,

      Malathi