AnsweredAssumed Answered

Can anyone fix this case?

Question asked by ngarnier on Nov 19, 2013
Latest reply on Nov 20, 2013 by philmodjunk

Title

Can anyone fix this case?

Post

     whatever I'm doing wrong, it's not working.
      
     field A should = 0,1,2,3,4,or 0 again if drop down choices for field B are either result1, 2,3,4,5, or 6 respectively.  I can't figure out how to return a result from the drop down without copying in the actual value.
      
     Field A=
      
     Case ( Field B = "result1" ; "0" ;
               Field B= "result2" ; "1" ;
               Field B = "result3" ; "2" ;
               Field B = "result4" ; "3" ;
               Field B = "result5"; "4" ; 
               Field B = "result6"; "0" ;)
      
      
     Note:
     result1 etc should be the command to return the first value from the list, not the copied value

Outcomes