Forum Discussion
IF statement comparing number and text
I want to create an IF statement that says if the value is greater than 90, then excellent, if it's 80-90, then good...etc. But keep getting error can't compare numbers and text. How can I do this?
hi Anonymous - Follow the below steps to compare a %age value and assign a corresponding value
1. You would need to create a calculated column as below:
Check = IF ([%age] > 0.9, "Excellent!!", IF ( [%age] <= 0.9 && [%age] > 0.8 , "Good!!", "Better luck next time!!"))Note: Ensure that the "%age" column is formatted as a numeric or %age columnPlease mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
5 Replies
- you will not be able to compare numbers and text, they are different data types. You will need to convert one of them. Can you you post your if statement please.
Also can you share a screenshot of your data.I have a calcuated field with a percentage, and I need to say if it is above this percentage, then assign them a status. I don't see how I can convert say a percentage of 88.5% into a string and say if it is greater than 88.5 then.....Less than and greater than won't work with a string will it?
Compliance Status = IF(CONVERT([Overall Compliance], string)>"80" , "Excellent", "BOOOOOOOO")
hi Anonymous - Follow the below steps to compare a %age value and assign a corresponding value
1. You would need to create a calculated column as below:
Check = IF ([%age] > 0.9, "Excellent!!", IF ( [%age] <= 0.9 && [%age] > 0.8 , "Good!!", "Better luck next time!!"))Note: Ensure that the "%age" column is formatted as a numeric or %age columnPlease mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Anonymous
I am able to compare a number and text.Column = IF('Table'[Percentage] >= 88.5, "Excellent", "Bad")
