Help

Create a "formula" group field from a "age" field

Topic Labels: Formulas
1004 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Viktor_Svensson
6 - Interface Innovator
6 - Interface Innovator

Hi, i have another thread here but it changed into this problem instead.

in the end i want a “age” field calculated from a “date” and i want to make a “formula” field that categories the age to groups.

so

I have a “date” field

and a “formula” field that calculates the age in one number “15” lets say

DATETIME_DIFF(TODAY(), {Date}, ‘years’)

and then have another “formula” field that groups all ages 1-100 in “1-12”, “13-18”, “19-29”, “30-45”, “46-60” and “61-100”

Formula found on internet but doesn’t work for me?

IF(
{Age} <= 12, ‘1-12’,
IF(
{Age} = 13, ‘13-18’,
IF(
{Age} = 14, ‘13-18’,
IF(
{Age} = 15, ‘13-18’
IF(
{Age} = 16, ‘13-18’
IF(
{Age} = 17, ‘13-18’
IF(
{Age} = 18, ‘13-18’
IF(
{Age} = 19, ‘19-29’
IF(
{Age} = 20, ‘19-29’
)
)
)

and so on…

then i could have a “app” with a “Chart” for: “1-12”, “13-18”, “19-29”, “30-45”, “46-60” and “61-100”
right??? or use the built-in group feature and group them all.

2 Replies 2

This seems to be a duplicate. How is this question different from the question at the end of your other post?

Hi, thank you for the help in the other thread. yes is the same question, but the other one started a bit different and evolved into another question.