Hello - I think, this is what you wanted :
I have taken a Sample data :
and my output is like this.
Step 1: Created a Field which can separate null and number field and round off to 1 digit
Step 2: Added the % symbol to the desired field
PS: If you find this solution helpful, don't forget to click the like button
Thanks for the reply.
I used almost the similar thought process.
The STR and ROUND functions are not giving expected results when they are used together.
Have to look for other workarounds.