This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Yes, you will miss decimal places. By converting to a string you will also lose the ability to perform other math calculations on this field. I'd suggest leaving it as a number (float?) and then formatting it in your presentation to show percentage sign with X decimal places. Even Excel does it that way.
I am sorry to jump on this conversation, but I have the same problem with number formatting in Alteryx.
To be precise, Excel does not do it in this way, Excel lets you change the format of a cell and show that as a percentage keeping the number format in case you want to perform any operation on that number.
I think that this kind of things should be definitely implemented in Alteryx, they are very simple things but that change much the output quality and make it readable. Did anyone already think about that?
Is there a way to add a % sign without converting it to a string. When i tried using this formula, i'm getting an error saying that the formula resulted in a string when the field is numeric... is there a way to fix that?