# % symbol to the decimal points

**URL:** <https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601>\
**Category:** Q&A\
**Tags:** parameters, calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [December 12, 2023, 10:12am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601 "2023-12-12T10:12:09Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [December 12, 2023, 11:14am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/6 "2023-12-12T11:14:41Z")

</div>

maybe you can have a look into

> [@Dynamic decimal places](https://community.amazonquick.com/t/dynamic-decimal-places/21448/15):
>
> 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]

---

_[View the full topic](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601)._