AnsweredAssumed Answered

Case calculation with conditions from two fields

Question asked by kaatzastation on Jul 6, 2016
Latest reply on Jul 6, 2016 by keywords

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.

Outcomes