Forum Discussion
Showing % with additional 00 in a column
The value cannot be changed from whole number into % as a percentage means that the value is divided by 100.
You can do one of 3 changes:
1. create a new column to divide the values by 100, e.g. column = [abc] / 100
2. concatenate % sign to the value, but the result will be text, e.g. column = [abc] & "%"
3. change the original calculation where the value came from, e.g. abc = <calculation> / 100
Resolver IVThe value cannot be changed from whole number into % as a percentage means that the value is divided by 100.
You can do one of 3 changes:
1. create a new column to divide the values by 100, e.g. column = [abc] / 100
2. concatenate % sign to the value, but the result will be text, e.g. column = [abc] & "%"
3. change the original calculation where the value came from, e.g. abc = <calculation> / 100