Hi @gian ,
This is start:
ifelse({CRV_pct} >= 10,
concat( split(toString(round({CRV_pct}, 0)), ".", 1), "%"),
concat( substring(toString(round({CRV_pct}, 1)), 1, 3 ), "%")
)
With the resulting display:
Notice that the substring() arguments are hardcoded to pick the first 3 characters. I think that’s OK because for a percent less than 10, it will always be a single digit number. If that’s true, than this should work for you.
Also note that as a string, you can’t do any numeric processing, like a sum() or max().
Let us know if that works for you.
Thanks to @ErikG for the string function ideas!
ws