Forum Discussion
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 column with below formula.
if [Value] = null then null else if [Value]=">95%" then ">95%" else if [Value] <= 1 then Number.ToText([Value] * 100) & "%" else Number.ToText([Value])
The result is
From to
It is worked in some percentage but I have a problem in some results like 7.00000000007%, 55.00000000007 and 19.9.000000000%, 3.500000004%
Best Regards,
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.
2 Replies
- AjithPrasathResolver II
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.
- slamFrequent Visitor
Thank you very much for your help!