# Show as number/percentage with dynamic variable

**URL:** <https://community.amazonquick.com/t/show-as-number-percentage-with-dynamic-variable/20899>\
**Category:** Q&A\
**Tags:** parameters, calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [November 7, 2023, 10:11am UTC](https://community.amazonquick.com/t/show-as-number-percentage-with-dynamic-variable/20899 "2023-11-07T10:11:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tancredidorsi](https://avatars.discourse-cdn.com/v4/letter/t/ed655f/32.png) [@tancredidorsi](https://community.amazonquick.com/u/tancredidorsi)\
**Post date:** [November 7, 2023, 10:11am UTC](https://community.amazonquick.com/t/show-as-number-percentage-with-dynamic-variable/20899/1 "2023-11-07T10:11:41Z")

</div>

Hello everyone,  
I have a calculated field in Quicksight which, based on the value of a parameter, takes a value which either a percentage or a number:  
ifelse(${PercentageorNot} = ‘Percentage’, {value in %}, sum(value))

When I insert this field into my visualization, I can’t find a way to change dynamically between the option of showing as number and showing as percentage. Is there a way to do so?

---

<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:** [November 8, 2023, 10:04am UTC](https://community.amazonquick.com/t/show-as-number-percentage-with-dynamic-variable/20899/2 "2023-11-08T10:04:43Z")

</div>

Hi @tancredidorsi  
i think that is not possible.  
But would it be a workaround to use 2 different visuals that you show/hide based on the parameter?  
BR

---

<div class="post-metadata">

**Author:** ![Kellie\_Burton](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/kellie_burton/32/2603_2.png) [@Kellie\_Burton](https://community.amazonquick.com/u/Kellie_Burton)\
**Post date:** [November 15, 2023, 8:23pm UTC](https://community.amazonquick.com/t/show-as-number-percentage-with-dynamic-variable/20899/3 "2023-11-15T20:23:23Z")

</div>

This has been marked as a feature request.

---

<div class="post-metadata">

**Author:** ![Kellie\_Burton](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/kellie_burton/32/2603_2.png) [@Kellie\_Burton](https://community.amazonquick.com/u/Kellie_Burton)\
**Post date:** [November 15, 2023, 8:23pm UTC](https://community.amazonquick.com/t/show-as-number-percentage-with-dynamic-variable/20899/4 "2023-11-15T20:23:28Z")

</div>