3 Replies Latest reply: May 15, 2014 10:07 AM by elginreigner _ RSS

    concatenate numeric Fields

    gico1972 _

      I trying to concatenate to numeric fields to create a new calculated field. The 2 fields are numeric however i am struggling to achieve this.

       

      Field A = "101" and Field B="5" and i am trying to return a numeric field showing"1015"

       

      i am using V8 if that makes any difference.

       

      Thanks in advance

        • concatenate numeric Fields
          Grant Perkins

          I trying to concatenate to numeric fields to create a new calculated field. The 2 fields are numeric however i am struggling to achieve this.

           

          Field A = "101" and Field B="5" and i am trying to return a numeric field showing"1015"

           

          i am using V8 if that makes any difference.

           

          Thanks in advance[/quote]

           

          You can only concatenate character fields so your formula needs to convert each field to Character, then concatenate, then (maybe?), convert back to numeric. You need the STR() function.

           

          However from what you are doing it sounds like the values could, maybe should probably be left as character fields.

           

          HTH.

           

           

          Grant