AnsweredAssumed Answered

case statement

Question asked by Sidhu on Aug 26, 2009
Latest reply on Aug 27, 2009 by etripoli


case statement


Hi Guys,

          I have 2 tables Students and Results.

In Results Table i have 2 feilds, Supplementary and marks. In Students table i have a feild called final. 


Now i need a calculation for the final feild, like




Supplementary = "";


Sum( Results::marks);




For the above sum results i need if Sum(Results::marks) < 40;




 Sum(Results::marks) > 40; 




 Sum(Results::marks) > 80;




So basically i need to satisfy more than one condition in case statement. is it possible.


Thanks in advance.