AnsweredAssumed Answered

Question regarding a Case Calculation

Question asked by terri_henry on Nov 15, 2017
Latest reply on Nov 15, 2017 by philmodjunk

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")
   
 
 
 
 
 
 
 
 
 
 
 





Outcomes