5 Replies Latest reply on Mar 17, 2016 7:50 AM by christina.butler

    Converting Numbers to Strings

    christina.butler

      Hello,

      I am trying to convert a numerical value to a string but I am running into issues. The numerical value has two decimal digits but when I convert to string, the values that end in .00 are converted to integers and some of the values have about 16 digits after the decimal point. I am working with student GPA data so it is important that the format be x.xx. Below are the steps I took to convert number to string:

      1. Duplicate measure value

      2. Convert to dimension

      3. Change data type to string

       

      Below is a screenshot of my result and I have attached a sample workbook:

       

       

      I thought this would be a relatively straightforward thing to do but just cannot figure out what is going on.