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...




      Kevin Storey