AnsweredAssumed Answered

What's wrong with what I'm doing??!!

Question asked by penhaifai on Jan 29, 2010
Latest reply on Jan 30, 2010 by casey777

Title

What's wrong with what I'm doing??!!

Post

 Please anybody help me with the following calculation;

 

 

Case ( 1st_illness_Age   <   5 ; "Under 5 years" ;
1st_illness_Age  <  14 ; "5-13 years" ;
1st_illness_Age  <  18 ; "14-17 years" ;
1st_illness_Age  <  25 ; "18-24 years" ;
1st_illness_Age  <  45 ; "25-44 years" ;
1st_illness_Age  <  65 ; "45-64 years" ;
"65+ years"  )

 

Thank you for Comment on helping me regarding the top calculation;

Identifying two periods of fyscal year!!

 

It does work with other fields but when i tried to apply it on that field it was disaster!! I made the adjustment so it should fit what I need here but all I got is;

                    

                      Gives you

1St illness age   =====>     1St illness age

 

 5  or  6                                45-64 years

 4                                        under 5 years

 7   till  9                               65+ years

10  till 49                              under 5 years

 65                                      65+ years

 50  till  64                          45-64 years

 

 

What's wrong with what I did??!!

 

 

 

 


Outcomes