AnsweredAssumed Answered

case statement

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

Title

case statement

Post

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

 

Case(

 

Supplementary = "";

 

Sum( Results::marks);

 

)

 

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

 

"Fail"

 

 Sum(Results::marks) > 40; 

 

"Pass";

 

 Sum(Results::marks) > 80;

 

"Distinction"

 

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

 

Thanks in advance. 

Outcomes