Hi everyone… I’m creating a Case Calculation in Filemaker Pro 16. Field #1 has 3 possible entries. (“R”, “B” or it will be blank). Field #2 will automatically calculate based on the entry in Field #1

If field #1 is “R” or “B”... field # 2 needs to be “Y”….. if Field #1 is blank/empty, field # 2 needs to be “N”. My calculation works great for the “R” and “B”… but I don’t know how to show the “if the field is Blank” in my calculation. Here’s what I have so far…….. (The blank is at the end of the calculation)

Case (PIMs student status code Calculation="B"; "Y" ; PIMs student status code Calculation="R"; "Y" ; PIMs student status code Calculation="?"; "N")

Case (PIMs student status code Calculation="B"; "Y" ;

PIMs student status code Calculation="R"; "Y" ;

IsEmpty ( PIMs student status code Calculation ) ; "N")