Forum Discussion
Helper Iconverting to percentage
Im trying to make this column percentage values so they dont come out as 3000.00% rather than 30%. Attatched is my formula for the calculated column and an example of how they are coming out.
dkehoe32 What is the value you are returning? 30 or .30? You need the output of the value to be in the decimal in order for the percentage to appear appropriately as it will always move the decimal two places to the right of your value. So, either do that on the base column value, or add "/ 100" to your lookup value to modify your output.
1 Reply
dkehoe32 What is the value you are returning? 30 or .30? You need the output of the value to be in the decimal in order for the percentage to appear appropriately as it will always move the decimal two places to the right of your value. So, either do that on the base column value, or add "/ 100" to your lookup value to modify your output.