Discussions

 View Only
  • 1.  Remove the % symbol in field without changing it to Numeric

    Posted 03-20-2020 14:40
    I need help removing the % symbol and adding additional digits in several Percent fields.  As it should, when I change the display options to simple number or change the field type to numeric it changes the format to .0125.   I need the number to stay as 1.25 and appear as a 5 digit number.  So, 1.2500 and 0.6750.

    At a loss for an solution other than reformatting all my data & re-importing.  


    ------------------------------
    Nikki Walters
    ------------------------------


  • 2.  RE: Remove the % symbol in field without changing it to Numeric

    Posted 03-20-2020 16:50
    Changing the decimal places to 4 will fix the number of digits:


    I don't know of a solution for the other issue other than for you to download as a spreadsheet, make a quick formula to multiply your value by 100 and then copy that column and paste values, then import using the Record ID# as the merge field; this will update only the values you have changed and will overwrite the old values.


    ------------------------------
    Adam Keever
    ------------------------------



  • 3.  RE: Remove the % symbol in field without changing it to Numeric

    Posted 03-25-2020 10:17
    I thought about this a bit more Nikki. You can use a formula numeric field with the following formula:

    [YOUR_PERCENT_FIELD] * 100

    Set display properties to 4 decimal places and display as a simple number:

    Here is the result:

    If you change the formula numeric field type to numeric, it will retain the values.


    ------------------------------
    Adam Keever
    ------------------------------