You need to sign in to do that
Don't have an account?
![Heng Wang Heng Wang](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
Convert text field to number based on if text field is empty
I want to create a report or a query to accomplish this:
Let's say we have field called color. If the color is green, it is assigned as 3 points. Yellow is 2 points. Red is 1 point. Now I want to get a list of contacts with their names and the points based on the color they picked. Something looks like:
Name Points
xxx 2
xxx 3
How to achieve this?
Thanks advance for any help!
Let's say we have field called color. If the color is green, it is assigned as 3 points. Yellow is 2 points. Red is 1 point. Now I want to get a list of contacts with their names and the points based on the color they picked. Something looks like:
Name Points
xxx 2
xxx 3
How to achieve this?
Thanks advance for any help!
I recommend Case.
Example, CASE(Color, "Green", 3, "Yellow", 2, "Red", 1, "Other", 0, 0)