5 Replies Latest reply: May 15, 2014 10:02 AM by Diane Miller RSS

    Zero Filling Number and removing decimal

    kstorey _

      Can anyone help me out with this one???

       

      I need to take a number with two decimals (for example 100.99) and remove the decimal and zero fill the front to get seven characters for the export to a text file.

       

      For example, in this example, the output would need to be 0010099.

       

      If the amount is zero, I would need to show a null or blanks.

       

      The source filed is called Amount.  I would imagine you would accomplish this with a calculated field.  I cannot use the export options because I have other fields that need the decimal point to stay...

       

      Not sure what else I need to do...

       

      Thanks,

       

      Kevin Storey