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, 51-60, 61 and over
------------------------------
Ermias Bean
------------------------------
Question
Age Range
This topic has been closed for replies.
+24np,
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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.