# How to convert number into percentage in calculated field?

**URL:** <https://community.amazonquick.com/t/how-to-convert-number-into-percentage-in-calculated-field/15735>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [July 14, 2023, 9:50am UTC](https://community.amazonquick.com/t/how-to-convert-number-into-percentage-in-calculated-field/15735 "2023-07-14T09:50:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![thecuon119](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/thecuon119/32/11037_2.png) [@thecuon119](https://community.amazonquick.com/u/thecuon119)\
**Post date:** [July 14, 2023, 9:50am UTC](https://community.amazonquick.com/t/how-to-convert-number-into-percentage-in-calculated-field/15735/1 "2023-07-14T09:50:07Z")

</div>

Hi, I’m trying to do cohort analysis. I want to convert number into percentage in calculated field. I figured out by using percentoftotal but the number is already calculated by distinct\_count. Then i hadto divide the number by the number in the first cell. I noticed it was the biggest one in the row so i wrote: {num\_of\_pub\_having\_order} / maxOver(max{num\_of\_pub\_having\_order}, [{transaction\_sales\_time}], PRE\_AGG). It kept saying error.  
Btw, i don’t know how to deal with such many 0 value and null row too. Thanks in advance !

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/5/576954c9b91cfe5782109d700152811a886880ee.png)

---

<div class="post-metadata">

**Author:** ![demola](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@demola](https://community.amazonquick.com/u/demola)\
**Post date:** [July 14, 2023, 10:05am UTC](https://community.amazonquick.com/t/how-to-convert-number-into-percentage-in-calculated-field/15735/2 "2023-07-14T10:05:27Z")

</div>

Hi @thecuon119,

Thank you for posting in the Amazon Quick Sight community.

Please review the link below to guide you.

> [@Converting number to percentage](https://community.amazonquick.com/t/converting-number-to-percentage/2942/4):
>
> Hi @aditya2268, It is not possible to change the format of a single cell in Quick Sight. As a workaround, you can create a calculated field for your productivity gain field and multiply it by 100. Then you can change the name of your productivity gain field to something like, “Productivity Gain Percentage”. Does this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community Q&A Forum!

If this was able to help, you can mark as solved.

Regards,  
Demola