1 Reply Latest reply: May 15, 2014 10:07 AM by Data Kruncher RSS

    Negative Values

    trsutton _

      I have imported data from a pdf file.  The file had numeric amounts and some were a negative value (ie  -134.25).  I needed this field to be 8 characters wide so had not problem padding the front of the field with zeroes, but it did not move the negative sign to the front of the zeroes.  Is there a way to quickly do this?  I am using Monarch 10

       

      Was

       

      -134.25

       

       

      Now shows as

       

      0000-134.25

       

       

      Need this to show as

       

      -0000134.25

        • Negative Values
          Data Kruncher

          Hi Tammy,

           

          Assuming that your original value is a Numeric field, then building a new Character calculated field using:

           

          If(MyValue<0,"-","0")+Str(Abs(MyValue),10,2,"0")[/CODE]

           

          should get you the results that you want.

           

          HTH,

          Kruncher