


I have a custom form with a calculated field, to show the average of the overall effort. "Overall Effort Average"
The custom form calculation is: AVERAGE(UX Effort,Design Effort,Dev Effort)
My report includes this calculated field as a column,
I would like to show whole numbers in my report, or perhaps just to one decimal point.
displayname=
linkedname=direct
namekey=Overall Effort Average
querysort=DE:Overall Effort Average
sortOrder=3
sortType=asc
textmode=true
valuefield=Overall Effort Average
valueformat=customNumberAsString
Additionally, can I utilize text mode to sort by a 4th column? I’m currently sorting by
Topics help categorize Community content and increase your ability to discover relevant content.
Hi Cathy,
To get the values to return as a whole number in your report, use the text mode below in your column.
displayname=
linkedname=direct
namekey=Overall Effort Average
querysort=DE:Overall Effort Average
sortOrder=3
sortType=asc
textmode=true
valuefield=Overall Effort Average
valueformat=customNumberAsString
valueexpression=ROUND({DE:Overall Effort Average},0)
Here we have added a value expression to the code which tells Workfront to round the custom field to 0 decimal places. If you wanted this to have one decimal place you would simple replace the '0' with a '1' in the value expression.
I'm not 100%, but I don't believe that you can sort by a 4th column, I think that 3 is the limit.
Best Regards,
Rich.
Hi Cathy,
To get the values to return as a whole number in your report, use the text mode below in your column.
displayname=
linkedname=direct
namekey=Overall Effort Average
querysort=DE:Overall Effort Average
sortOrder=3
sortType=asc
textmode=true
valuefield=Overall Effort Average
valueformat=customNumberAsString
valueexpression=ROUND({DE:Overall Effort Average},0)
Here we have added a value expression to the code which tells Workfront to round the custom field to 0 decimal places. If you wanted this to have one decimal place you would simple replace the '0' with a '1' in the value expression.
I'm not 100%, but I don't believe that you can sort by a 4th column, I think that 3 is the limit.
Best Regards,
Rich.
Thank you, @Richard Leek‚!
Views
Replies
Sign in to like this content
Total Likes