Forum Discussion
Responsive Resident% sign on the value
Hi,
This has never happened to me before, I am working with an excel file that comes with column User Percent value as such 99.23, 99.41, 97.10 or 78.90. I was trying to place the percent sign next to it but when I do that the value changes from 99.23 to 9923.10, 9941.34, 9710.22 what can I do to see the value as 99.23% & 99.41%.
Thank you!
Hi sraj
In a new column called (%value) divide the column which contains the values you want to display by 100. Add then this new column in your visual and enable % in the menu
Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated
2 Replies
- DataVitalizer
Super User
Hi sraj
In a new column called (%value) divide the column which contains the values you want to display by 100. Add then this new column in your visual and enable % in the menu
Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated
srajThat worked, thank you!!