Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Custom field needs leading zero in report.

Avatar

Level 2
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
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Employee Advisor
@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

Avatar

Level 2
Perfect, thank you so much!! Chris Langan Canandaigua National Corporation