How to convert the a decimal into a percentage

[ASHccccc]

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.

[messi007]

@ASHccccc,

Please see below :

Attached the workflow,

Hope this helps!

Regards

[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)+'%'

[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 · Accepted solution]

@ASHccccc,

You can update the formula like below :

Hope this helps !

Regards

[ASHccccc]

great!!!! thx  a lot!!!!!!!!!!!!!!!!!!!