How to convert the a decimal into a percentage

sorry that it maybe a stupid question.......😓 a new bird is still learning, and keep learning.... tried to check the help center but soooo unluckily that found nothing.....

just a simple request, how to conver 0.5 to 50%......

Thx for your time anyway for reading this post, and appreciate your help in advance.

Custom Tools

Apps

Accepted answers

messi007

@ASHccccc,

You can update the formula like below :

Hope this helps !

Regards

All comments

messi007

@ASHccccc,

Please see below :

Attached the workflow,

Hope this helps!

Regards

Convert_20220805.yxmd

DataNath

Hey @ASHccccc, as far as I know the only way to create a percentage in that exact format with the notation is to create a string field with something along the following lines as an expression - just need to replace [Number] with your field:

ToString([Number]*100)+'%'

Number to percentage.yxmd

ASHccccc

thx for the prompt response @messi007, may I ask one more question that how to make the decimal places 2 digits only? when some results came out like 0.33333333333, it'll show a long long number....

davidskaife

Hi @ASHccccc

Use this expression within the formula:

ToString(Round([Field1]*100,0.01))+"%"

messi007

@ASHccccc,

You can update the formula like below :

Hope this helps !

Regards

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703