Hello,
This is my first "bigger" assignment in WebFocus - please help:

I need to create 11 age groups:
>30, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, over 74
- Need to get total of individuals in each age group age group and a total of Life Insurance coverage for each age group.

Is there a Function to achieve that, so that it can be done in a single report?
Any help is appreviated!
Stella

I think this is similar to what I did for a report....

I had to group data based on 'days late' for an order. I defined a field called MyRange and assigned the field values (that resemble headings) such as ' 1-5 days':

MyRange/A20= IF DAYSDIFF LE 5 THEN ' 1-5 Days ' ELSE IF DAYSDIFF LE 10 THEN
' 6-10 Days' ELSE
IF DAYSDIFF GE 11 THEN ' Over 11 Days' ELSE 'Unknown ' ;

Then, you use your ACROSS Sort to group the data:

ACROSS MyRange AS 'Days Late'

Instead of my field, DAYSDIFF, you would look at your AGE field.

Hope this helps!