Export number field as a decimal | Community
Skip to main content
N
NickVa7
Level 9
April 6, 2021
Question

Export number field as a decimal

  • April 6, 2021
  • 1 reply
  • 589 views

Hi WF Community,

I have a custom field (number) that I've included as a column in a report. We have people enter values as decimals (e.g. 85% would be entered as .85). This data shows up correctly in reports as a decimal; however, when we export to Excel, it rounds it to a whole number (e.g. 1).

Is there a way to control this so when it's exported it shows up as the decimal value that was entered and displaying in Workfront?

Thanks.

Nick

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    C
    chank22
    Level 2
    December 21, 2022

    Hi Nick,

    I came across your post while searching for my own question which i think you might have the answer to. It sounds like you are able to capture a custom form field data into your report is that correct? If so, please share which report type you used!

     

    Your help is much appreciated!

    Terms & ConditionsAccessibility statement

    Loading footer...