# Create 4 Year Schedule

The following portion of my query shows columns that represent the first year of a 4 year report.

I will have four more sets of these columns that will reflect the count dates for the next three years.

How do I correctly calculate  the next three years?
A parts are counted 2xs per year  - CountFREQ = 180
B parts are counted 1x per year -  countFreq =  365
C parts are counted every two years - countFreq = 730
D parts are counted every 4 years - countFreq = 1460

To get the next count date for the first year I add the count frequency to the last count date and I have a date.

I'm not sure how to get the next three years of dates to show up correctly.

``````NEXT_Y1A1_COUNT =
CASE
WHEN P.ABC_CODE = 'A'

NEXT_Y1A2_COUNT =
CASE
WHEN P.ABC_CODE = 'A'

NEXT_Y1B_COUNT =
CASE
WHEN P.ABC_CODE = 'B'

NEXT_Y1C_COUNT =
CASE
WHEN P.ABC_CODE = 'C'

NEXT_Y1D_COUNT =
CASE
WHEN P.ABC_CODE = 'D'
``````
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Just use a multiplier:
``````NEXT_Y1C_COUNT =
CASE
WHEN P.ABC_CODE = 'C'

NEXT_Y1D_COUNT =
CASE
WHEN P.ABC_CODE = 'D'
``````
0

Experts Exchange Solution brought to you by