Forum Discussion

Del's avatar
Del
Qrew Cadet
5 years ago

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, 51-60, 61 and over

------------------------------
Ermias Bean
------------------------------
Formulas and functions

5 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------
    • Del's avatar
      Del
      Qrew Cadet
      5 years ago
      Ahh, great. Thank you

      ------------------------------
      Ermias Bean
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        I 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
        ------------------------------
    • CassieHubble's avatar
      CassieHubble
      Qrew Cadet
      2 years ago
      Did I miss something? 



      ------------------------------
      Cassie Hubble
      ------------------------------
      • LauraThacker's avatar
        LauraThacker
        Qrew Captain
        2 years ago
        @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
        ------------------------------