5 Replies Latest reply: May 26, 2016 2:11 PM by Olly Bond RSS

    How can I replace blanks in a field with a zero?

    Wendy Hilliard

      I have a field in my report that leaves blanks where there are preceeding zeros in the number.  Making a 4 digit number like 0013 look like   13.


      I need the model to place 2 zeros in there.  I am working on the answer in Excel and can get it but would prefer to model and export with it corrected in order to make the process smoother.


      Any suggestions?