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
np,
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
------------------------------
Did I miss something?
------------------------------
Cassie Hubble
------------------------------
------------------------------
Cassie Hubble
------------------------------
- @Cassie Hubble - your formula-field is a numeric output which cannot show a "range". You need to convert your formula to formula-text for your formula to work.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
