Round Portofilio On-Time to two decimal places

[AnnieXLe]

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 solution]

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-i... 

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... 

[AnnieXLe]

Thank you! This is amazing.