"IF" Statement for % values are not working.

[StuartSmith]

I have a Custom Coumn called "AttritIon" that creates a percentage value column, I then have another Custom Column called "KPI" that identify if the "Attrition" column values are "Out of KPI" or Within KPI", but the "Within Attrition KPI" isnt working. 

Within Attrition KPI = IF('Cuser Archive data'[Attrition]>5,"Out of KPI","Within KPI")

Anything below 5% should be "Within KPI", otherwise "Out of KPI", but as you can see, its not working.

Thanks in advance.

[Jihwan_Kim · Accepted solution]

Hi,

Please try something like below.

Within Attrition KPI =
IF ( 'Cuser Archive data'[Attrition] > 0.05, "Out of KPI", "Within KPI" )

[StuartSmith]

That worked, so thanks, but why? 😁