I am trying to group ages of victims of crime. One group is 15 and under, the second is 16 and above. The 15 and under group is incidents.age <= "15". Because of the way the system looks at this particular field, any single digit over 1, is being grouped into the 16 and above category. I'm not sure how to change this field to have it read as consecutive numbers (i.e. 1,2,3,4 etc.) I know there has to be a simple solution....any suggestions? Thanks for any help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
reformatting a numerical value to group correctly
- Thread starter ssiroky
- Start date
The reason it is currently grouping the way it is is because your age field is a string, not a number.
You'll need to convert the field from a string to a number. You can use:
tonumber({your.age.string})
Then set up your grouping using the new formula field instead of the age field.
Mike
You'll need to convert the field from a string to a number. You can use:
tonumber({your.age.string})
Then set up your grouping using the new formula field instead of the age field.
Mike
- Status
Similar threads
- Locked
- Question
- Locked
- Question