# Can I display the numerator and percentage in the same field?

**URL:** <https://community.amazonquick.com/t/can-i-display-the-numerator-and-percentage-in-the-same-field/5069>\
**Category:** Q&A\
**Tags:** calculations, formatting, quick-sight\
**Created:** [August 1, 2022, 2:27am UTC](https://community.amazonquick.com/t/can-i-display-the-numerator-and-percentage-in-the-same-field/5069 "2022-08-01T02:27:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kashgar](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/kashgar/32/24252_2.png) [@Kashgar](https://community.amazonquick.com/u/Kashgar)\
**Post date:** [August 1, 2022, 2:27am UTC](https://community.amazonquick.com/t/can-i-display-the-numerator-and-percentage-in-the-same-field/5069/1 "2022-08-01T02:27:12Z")

</div>

HI QS Community!

I want to display the numerator and percentage in a field. Essentially I want a table that will show values in a table like this: 3 (34%).

**I’m trying to recreate this :**

 ![Screen Shot 2022-07-31 at 7.25.47 PM](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/bf3969532180a50441c2d96510d181d2ac49fe76.png)

Thanks!

---

<div class="post-metadata">

**Author:** ![jingyali](https://avatars.discourse-cdn.com/v4/letter/j/76d3ee/32.png) [@jingyali](https://community.amazonquick.com/u/jingyali)\
**Post date:** [August 1, 2022, 9:49pm UTC](https://community.amazonquick.com/t/can-i-display-the-numerator-and-percentage-in-the-same-field/5069/2 "2022-08-01T21:49:52Z")

</div>

Hey Mike,

We can use [concat](https://docs.aws.amazon.com/quicksight/latest/user/concat-function.html) to display two or more strings in a field.  
Note that argument of `concat` must be a string, so we may need to [toString](https://docs.aws.amazon.com/zh_cn/quicksight/latest/user/toString-function.html) to convert number input.

Please check sample below:

Input data: numerator, percentage

Calculated fields:

```auto
percentage in string = toString({percentage} * 100)

concat field = concat(toString({numerator}), " (", substring({percentage in string}, 1, strlen({percentage in string}) - 3), "%)") 
// Using substring to format percentage to 1 decimal places like your sample

```

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/a/a54c643d4d258589e13122d2e4879fca328ca6a6.png)

Hope this answer your question 😀

---

<div class="post-metadata">

**Author:** ![Kashgar](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/kashgar/32/24252_2.png) [@Kashgar](https://community.amazonquick.com/u/Kashgar)\
**Post date:** [August 3, 2022, 7:32pm UTC](https://community.amazonquick.com/t/can-i-display-the-numerator-and-percentage-in-the-same-field/5069/3 "2022-08-03T19:32:41Z")

</div>

Thank you so much! This is perfect!