Banding

[kevbrown]

Easy one I'm sure and I think I need to use the class function but just to check

I have a Straight table of data and i need a banding column,  The column I need banded is Project Period with values of 0 up to 96. I need these banded in 0<10, 10<20, 20<30 etc.

Should i use the class function

[Gysbert_Wassenaar · Accepted solution]

If your intervals are all the same then the class function is the easiest way to create the bands: class([Project Period],10)

[kevbrown]

What if the intervals are different. For example. I have a field that i want to count and put into bandings of - 1,2,3,4,5,6,7, 8-14, 15-21, 22-28, 29 days - 6 months, 6 months - 12 months and > 12 Months

Kev

[Gysbert_Wassenaar]

You can use a largish nested if statement or create another table with the intervals and use the intervalmatch function to match the intervals to your period values.