I have a database for schools where we track GPA for each semester the kid has been in school. I want to tally (for a Risk Factor field) if the youth has less than a 2.0 then that would indicate ONE point and so on - for 8 semesters. Here is my calculation:

Sum

(Case ( s_0405DecGPA<2 ; 1 );

Case ( s_0405MayGPA<2; 1 );

Case (s_0506DecGPA<2; 1 );

Case (s_0506MayGPA<2; 1 );

Case (s_0607DecGPA<2; 1 );

Case (s_0607MayGPA<2; 1 );

Case (s_0708DecGPA<2; 1 );

Case (s_0708MayGPA<2; 1 );

)

My problem is that if a field is blank, FM thinks (of course) that that is less than two as all fields may or may not be filled in. What do I add to my calc to exclude those fields that are empty. I FEEL like this is simple.

Thanks in advance.

Sarah

Edited March 26, 200817 yr by Guest

Case ( not isempty(s_0405DecGPA) AND s_0405DecGPA<2 ; 1 )

perfect! thank you!! I had tried IsEmpty - but forgot or didn't know to put "not" in front... i knew it was simple!

thanks very much