Age Range
Looking for a formula of some sort that calculates an age if it falls within a range - for a pie chart. I dont want all of the ages to be displayed in the pie but something like 20-30, 31-41, 42-50, 5...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
Just make a formula numeric called Age Range.
IF(
[Age] <=10, " 0-10",
[Age] <=20, " 11-20",
[Age] <=30, " 21-30",
etc...
[Age] <=100, " 90-100",
[Age]>100, "100+")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Just make a formula numeric called Age Range.
IF(
[Age] <=10, " 0-10",
[Age] <=20, " 11-20",
[Age] <=30, " 21-30",
etc...
[Age] <=100, " 90-100",
[Age]>100, "100+")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Ahh, great. Thank you
------------------------------
Ermias Bean
------------------------------
------------------------------
Ermias Bean
------------------------------
- MarkShnier__YouI should have explained that the leading space in my formula was to preserve the sort order so that the 100+ would be less.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------