Converting number to percentage

[aditya2268]

I am trying to convert a number in one of the rows to percentage. In the attached image, I am trying to convert 0.29 to 29%, please advise.

[lillie]

If you go to the field wells you can save the value to be shown as a percentage. See here:

Will that work for you? Or do you just want that one number to show as a percentage rather than any value from that field?

[aditya2268]

Thanks Lillie. I think this converts entire column to percentage. I am just trying to convert that one single cell in the row to percentage, is there a way to do that? In the image, I am just trying to convert 0.29 to 29%

[WLS-P]

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!