Generating rows for Age Ranges.

[SM66215]

Good morning.

I'm trying to generate a row count for two different age ranges. I have a range that goes from 0-34 and then it moves to 9 year increments after that (See Attached) all the way to 95. I can get the count from 0-34, but from age range 35-44 the count starts over from 1 through 9. I would like the count to start at 35-44 all the way to 95 and beyond. 

Also is there a way for my count from 0-34 to start at Zero instead of 1? 

Thanks for all your help!!!

[mceleavey · Accepted solution]

Hi @SM66215 ,

You simply needed to account for your minimum and maximum ages within each group.

I amended your Generate Rows setup to accommodate this:

I also set your max age on the final group to 120.

This gives you the zero age:

and your ages per group:

Workflow attached,

I hope this helps,

M.

[SM66215]

@mceleavey 

Thank you so much!! This is what I needed!

[mceleavey]