# % symbol to the decimal points **URL:** \ **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:** 14\ **Page:** 1
**Author:** ![Vysh27](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vysh27](https://community.amazonquick.com/u/Vysh27)\ **Post date:** [December 12, 2023, 10:12am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/1 "2023-12-12T10:12:09Z")
Hi , I want to show a percent symbol next to the numeric field of the dataset which also dynamically changes according to the decimal control I’ve created. When I create a calculated field and adding it to the visual it’s taking as a string and it’s giving the count instead of the numerical number. How do I change it so it gives me as a sum Need help on this ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/d/d64ab52e087053c05d31343843a47216cfc24127.png) ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/5/5c661de76cbe5ac94d5146e43af881602f16fe91.png) ---
**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, 10:18am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/2 "2023-12-12T10:18:01Z")
Hi @Vysh27 you are creating a string field that cant be summed up. Its like sum A and B. But why not format/show the `Sales` as Percent? ![grafik](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/0e804f3fe39522fe79f294e505cf354596457bba.png) BR ---
**Author:** ![Vysh27](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vysh27](https://community.amazonquick.com/u/Vysh27)\ **Post date:** [December 12, 2023, 10:20am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/3 "2023-12-12T10:20:31Z")
when I try to format the sales as percent, the parameter that i’ve created to show the decimal points doesn’t work How Can I make the parameter work by formatting the sales as percent? ---
**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, 10:25am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/4 "2023-12-12T10:25:22Z")
Other way around. What do you want to achieve with the parameter and your sales field? Can you share a sample? ---
**Author:** ![Vysh27](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vysh27](https://community.amazonquick.com/u/Vysh27)\ **Post date:** [December 12, 2023, 10:54am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/5 "2023-12-12T10:54:47Z")
![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/2ce65bd3cc03ae7b463c9abbc1c750c462e487b4.png) As you can when I change the control to 2 the decimals in the numerical field also change to 2 ---
**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")
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] ---
**Author:** ![Vysh27](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vysh27](https://community.amazonquick.com/u/Vysh27)\ **Post date:** [December 12, 2023, 11:28am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/7 "2023-12-12T11:28:18Z")
![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/d/d0310319ec3116303b1d0514082a698d9a0b0c29.png) ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/3/3987641083f98e61f6543ce1274f63d103922b8c.png) It’s still taking it as count and not showing the numbers according to the fixed decimal ---
**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:54am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/8 "2023-12-12T11:54:38Z")
Because you still creating a sting and not a number. ---
**Author:** ![Vysh27](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vysh27](https://community.amazonquick.com/u/Vysh27)\ **Post date:** [December 12, 2023, 12:05pm UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/9 "2023-12-12T12:05:54Z")
okay , but how was Gian able to achieve it as a sum and not count Help me with this ---
**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, 12:14pm UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/10 "2023-12-12T12:14:00Z")
Not sure he used sum or was looking on row level. But i would say you will only achieve a sum if you format it instead of casting it into a string. ---
**Author:** ![Vysh27](https://avatars.discourse-cdn.com/v4/letter/v/3d9bf3/32.png) [@Vysh27](https://community.amazonquick.com/u/Vysh27)\ **Post date:** [December 13, 2023, 9:21am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/11 "2023-12-13T09:21:50Z")
Any alternate way how I can Achieve what I want? How Can I add the % symbol and Show it as a number and not count ---
**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 13, 2023, 9:26am UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/12 "2023-12-13T09:26:59Z")
As I said only if you format the field that its keeps a numeric value. Maybe you have to adjust the decimal parameter. ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [December 28, 2023, 5:43pm UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/13 "2023-12-28T17:43:06Z")
Hello @Vysh27 ! Was @ErikG 's suggestion helpful, and if so could you mark their comment as a solution to help the community? It has been some time since we have heard from you but we would still like to help you find a solution. If we do not hear from you in the next 3 business days this post will be archived. ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [January 2, 2024, 4:02pm UTC](https://community.amazonquick.com/t/symbol-to-the-decimal-points/22601/14 "2024-01-02T16:02:11Z")