3 Replies Latest reply: May 15, 2014 9:58 AM by Grant Perkins RSS

    Concatenate Character Fields

    Scott Blaylock

      I'm using MonarchPro V8

       

      I have two fields that are "character" fields

       

      Chrg-Dollars = (0002)

      Chrge-Cents = (03

       

      When together should read $2.03

       

      I have to bring them in separately because there is no decimal between them, I usually add this in Excel, but would like to do it in Monarch ahead of my export.

       

      I use this Formula to concatenate the two fields into a new calculated field:

       

      [font="courier"] "." /font[/quote]Now my new calculated character field looks like this:

       

      0002.03

       

      How do I get this into a numeric filed.  I can't just change it to numeric, I get an expression error.

       

      Any ideas or maybe you guys know a better way to do this.