3 Replies Latest reply on Jan 30, 2010 8:37 AM by casey777

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

    penhaifai

      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??!!