% symbol to the decimal points

[ErikG]

maybe you can have a look into

Dynamic decimal places

Thank you SO much @wstevens01 . That worked! I just nested that into another ifelse to aoid the ‘%’ to still show up even if the conversion is not applicable. see below. [image] Final calculation: ifelse( isNotNull({CVR dyn. dec.}), ifelse({CVR dyn. dec.} >= 10, concat( split(toString({CVR dyn. dec.}), ".", 1), "%"), concat( substring(toString({CVR dyn. dec.}), 1, 3 ), "%") ), NULL ) [image]