Get rid of the quotes around your numbers. Write your percentages as decimals. Write 90% as 0.9 For example.
Writing your calculation with either form of inequality operator should work once you fix the notation errors.
I think some of your case statements are close, but I think what's causing the problem is that you're checking if there is a value of "99.00%."
While that might be what you see as the end user, usually FM just sees that value as an integer or even a decimal depending upon your design.
Have you tried something like this?
Isempty ( FY16 CurrentYearUnExcAttendanceRate) ; "" ; // if no value set field to empty string ""
FY16 CurrentYearUnExcAttendanceRate > = .9 ; 1 ; // if greater than 90%
0 // default result, if neither of above match, default value is 0
Thank you! I based on your recommendations, I changed it and it worked!
Case (FY16 CurrentYearUnExcAttendanceRate >= .9; 1; 0)
If you still want to empty the field when there's no attendance rate calculated so far, you'll wanna add that to your Case().