Rounding and Adding Percentage Symbol

[KamenRider]

Hi Alteryx Community,

I would like your help in converting results to whole numbers and percentages. In my example below, the value is -45.454545454555, and I would like the result to be 45%. When I round it, the result is 46, which is incorrect because it should follow the rule for rounding even numbers and be 45.

Please advise on the correct formula to use. I have attached the workflow for your reference.

Thank you, and I look forward to your response.

Kamen

[aatalai · Accepted solution]

@KamenRider you wrote the first Change perecentage a as string field, so needed to convert it to a number first in change percent 2 this updated expression should do the trick. I've also added an updated workflow, please let me know how you get on.

tostring(abs(Round(tonumber([Change_Percent]), 1)))

[KamenRider]

Thank you so much @aatalai 

Kamen