Custom field needs leading zero in report. | Community
Skip to main content
C
ChristineLa
Level 2
January 28, 2020
Question

Custom field needs leading zero in report.

  • January 28, 2020
  • 2 replies
  • 565 views
Hi, I have a custom field that holds a GL account number. If that account number has a leading zero then it is dropped in my report. Is there a way to force the leading zero to show? For example account number is 0101 and my report shows 101. Thanks, Chris Chris Langan Canandaigua National Corporation
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

NicholeVargas
Adobe Employee
NicholeVargasAdobe Employee
Adobe Employee
January 29, 2020
@Chris Langan If this number does not ever need to be summed, multiplied or used in any mathematical calculation, I would recommend changing the format of your custom field from Number to Text. This will keep the 0 in front for reporting. If you are unsure how to do this, go into Setup > Custom Forms > Select your Custom Form > Select the Custom Field "GL Account Number" and there you will see a dropdown menu for Format that you will want to adjust. If you have any questions, let me know! Nichole Vargas Customer Programs Specialist, Workfront
C
ChristineLaAuthor
Level 2
January 31, 2020
Perfect, thank you so much!! Chris Langan Canandaigua National Corporation
Terms & ConditionsAccessibility statement

Loading footer...