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.
- As an example, I am seeing “4.3333333333” for one item but would like to see “4” or “4.3”.
- The text mode of the column is below. Is there a different valueformat that I should use?
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
- Business Value
- Priority
- Overall Effort Average
- I would like to add a 4th sort on the Entry Date column