Expand my Community achievements bar.

Export number field as a decimal

Avatar

Level 10

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

Topics

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

1 Reply

Avatar

Level 2

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!