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:




      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.