How to show % but remain as number that being able to use for calculation?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am a new user of Alteryx (only 2 week-old!)
I checked the solution of showing % sign, but the answers are just using the String. Meaning, il will become just a Text, not number.
However, in my output Excel file, I need the % remains as a number, so that users can use the colomn to do calculation.
Does anyone know the good solution?
Thanks for your help!
Amy
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Unfortunatley, alteryx doesnt play well with units in the same field as the value. if it was me, i would take the percentage value as a comma value (so 25% is written as 0.25). those numbers would act the same as you are used to in excel. Once you have it in excel you can change the formatting if you realy want to, but its only cosmetic
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
One option might be a table tool. You can set a % suffix on a field, and Excel still interprets the output as a number for calculations.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It seems like more of an issue with "formatting" in excel and keep things in Excel as numeric values.
One way to is to write the output to Excel in "double" / "floating" format and preserve the format, as follow:
You can now Preserve Formatting on Overwrite when overwriting a sheet or range via the Output Data tool Options. In order to preserve formatting, you have to:
- Select Overwrite Sheet or Range via Output Options.
- Specify cell ranges in the output file path.
Hope this works for you
Dawn.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you @Christina_Hurrell. I tried it and it works, but it put % directly without firstly multiple the result by 100.
result: 0.62, meaning 62%, with this method, it puts % directly after 0.62, which is 0.62%, instead of 62%.
One solution is to go back to my original calculation and change the formula to *100, however, I prefer to keep the "correct" calculation.
Do you know a better solution?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Christina_H
That's an amazing method I was not aware about it. Thank you for sharing and this learning opportunity 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @DawnDuong, I shall try it when I know more about Alteryx.