3 Replies Latest reply on Jul 6, 2016 3:14 PM by keywords

    Case calculation with conditions from two fields

    kaatzastation

      Hello,

           I am trying to come up with a case calculation using two fields to make the result. something like,

      Case (

      Field 1 >  condition A and Field 1 < condition B  and Field 2  = condition C ; Result 1 ; 

      Field 1 >  condition A and Field 1 < condition B  and Field 2  = condition D ; Result 2 ;

      Field 1 >  condition E and Field 1 < condition F  and Field 2  = condition G ; Result 3 ;

      Field 1 >  condition E and Field 1 < condition F  and Field 2  = condition H ; Result 4 ;

      )

      however I have tried using this in my calculation and its not working. I think I have a syntax error some place. Please help, all feilds conditons and results are numbers.