Dataset Column with a Formula

#1

I have a field called elig_type that I would like to base on a dataset called eligibility_type to control the frequency of the 3 items in the first column of the dataset. I have tested it out and it works well in my schema. However, elig_type should also be based on the age field so that if age is less than 18, it will return ‘blind and disabled under 18’. I would like to have both a formula and the dataset column. Any suggestions? A screenshot of the dataset is attached.

Link to Schema

#2

You can use an inline formula on your elig_type field with a value of “if age < 18 then “blind and disabled under 18” else this end”

This will take the value generated from the dataset and convert it to “blind and disabled under 18” when age is less than 18.