Forum Discussion
Solved
Text to Percentage
Dear All, Please help me to solve this problem. There are including percentages( 0.96 ) and numbers (3100) in a column. So, i want to convert percenatage 0.96 to 96%. Therefore, I add custum colum...
Please try the below code:
NewColumn =
IF (
ISBLANK ( [Value] ),
BLANK (),
IF (
[Value] = ">95%",
">95%",
IF (
[Value] <= 1,
FORMAT ( [Value] * 100, "0.00%" ),
FORMAT ( [Value], "0.00%" )
)
)
)Best Regards,
Ajith Prasath
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please try the below code:
NewColumn =
IF (
ISBLANK ( [Value] ),
BLANK (),
IF (
[Value] = ">95%",
">95%",
IF (
[Value] <= 1,
FORMAT ( [Value] * 100, "0.00%" ),
FORMAT ( [Value], "0.00%" )
)
)
)
Best Regards,
Ajith Prasath
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your help!