Changing my weakth quintile percentile to five categories

[Geteneh]

Dear team

Could you support me how to convert my percentiles values to five categories?

See attached

[DallasBaba]

@GetenehYou can change the column from text to a Decimal number and set the number on decimal you would like to display.

You can use the following code to set a dynamic category base on your preference 

Category =

SWITCH(TRUE(),

    [IWItot] <= PERCENTILE.INC([IWItot], 0.2), "Very Low",

    [IWItot] <= PERCENTILE.INC([IWItot], 0.4), "Low",

    [IWItot] <= PERCENTILE.INC([IWItot], 0.6), "Moderate",

    [IWItot] <= PERCENTILE.INC([IWItot], 0.8), "High",

    [IWItot] <= MAX([IWItot]), "Very High"

)

 

Let me know if this works

Thanks

 

Spoiler

[Geteneh · Accepted solution]

Thank you, it works now

[DallasBaba]

@Geteneh Thanks for letting me know this works for you.

Kindly Like the post and consider accept it as the solution  to help the other members find it more quickly.

Thanks
Dallas