AnsweredAssumed Answered

Can you help fix a calculation?

Question asked by akowitz on Apr 7, 2017
Latest reply on Apr 7, 2017 by kazznfx

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!

Outcomes