1 Reply Latest reply on Apr 23, 2009 8:24 AM by raybaudi

    Case in a Case is this possible

    user21370

      Title

      Case in a Case is this possible

      Post

      Hello,

       

      Is it possible to make a case in a case function?

      I've made the next script but it doesn't show the right result:

       

      Case ( IsEmpty ( FIELD 1 ) ; "" ; not IsEmpty ( FIELD 1 ) ; Case ( "60" ; "1" ; "50" ; "2"  ) ) 

       

      Thanks in advanced!

       

        • 1. Re: Case in a Case is this possible
          raybaudi
            

          Hi Hans

           

          That calc can't work because lacks of something...

           

          If I understand you correctly, you had to write:

           

          Case( IsEmpty ( FIELD 1 ) ; "" ; not IsEmpty ( FIELD 1 ) ; Case ( Field 1 = "60" ; "1" ; Field 1 = "50" ; "2"  ) ) )

           

          BTW: the calculation can be simpler:

          Case(
          Field 1 = 60 ; 1 ;
          Field 1 = 50 ; 2
          )