AnsweredAssumed Answered

Formatting a numeric field- round to 10s or 100s

Question asked by AaronAE on Aug 13, 2019
Latest reply on Aug 13, 2019 by Dan_Patterson

When formatting a numeric field in a table, rounding to decimal places or significant numbers is straightforward- but how do I round to the nearest 10 or 100 (ie to the left of the decimal)? My numbers range from 41 the over 1,000,000 and I'd like them all to display as x,xxx,xx0. I've played around with all the numeric options and custom formatting, but can't find a way- is it possible?

Outcomes