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.
