I'm trying to create a calculation field that puts a number 1 in the field, if the attendance rate is 90% or higher. If it's less than 90%, it needs to be a 0, and blank if there's no attendance rate calculated so far. Been trying the "Case" and "If" functions and can't seem to get it right. Seems like FM doesn't like the ≥ or ≤ signs. So then I tried to show is as >= and that didn't work either. Here's some of the attempts:

- If(FY17 CurrentYearUnExcAttendanceRate ≥ "90.00%"; "1"; If(FY17 CurrentYearUnExcAttendanceRate ≤ "89.99%"; "0"))
- If(FY17 CurrentYearUnExcAttendanceRate > "89.99%"; "1"; If(FY17 CurrentYearUnExcAttendanceRate < "90.00%"; "0"))
- Case (Met Objective = "1" and FY16 CurrentYearUnExcAttendanceRate ≥ 90 ; 0 ; Met Objective ≠ "1" and FY16 CurrentYearUnExcAttendanceRate ≤ 89.99; 0 ; FY16 CurrentYearUnExcAttendanceRate )
- Case( Met Objective = "1" and FY16 CurrentYearUnExcAttendanceRate ≥ 90 ; 0)
- Case( Met Objective = "1" and FY16 CurrentYearUnExcAttendanceRate >= 90 ; 0)

Can someone help? Thank you!

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.