Round Portofilio On-Time to two decimal places

Question

I am having some challenge with rounding the Portfolio On Time number to two decimal places. I followed the instructions from the resources I found on the Workfront community and Experience League but with no success. I have tried replacing the valuefield with valueexpression but no value display. Not sure if I am putting the right text code in the right field. Can someone help me determine what am I doing wrong?

Text Mode: On Time

listsort=HTML(onTime)
namekey=onTime
querysort=onTime
stretch=0
textmode=true
valuefield=ROUND({onTime},2)
valueformat=HTML
width=200

skyehansen · Accepted Answer

If you only want to round the number, just try using the onTime valuefield with a valueformat from the following list (maybe doubleAsDouble would be best)

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/format-numbers-in-text-mode-reports.html?lang=en

Also here's some info on the difference between valuefield and valueexpression

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/text-mode-syntax-overview.html?lang=en