5 Replies Latest reply on Aug 15, 2018 4:24 PM by Deepak Rai

    Preventing calculations with variables with empty fields

    Carmon Greene

      I created a calculated field names "symptom change" that grouped the variable "rank difference" into 3 categories (better, worse, no change). The issue I am running into, is that the "symptom change" field is being calculated for patients who have no values in the "rank difference" field. How can I prevent this from happening?.

       

          

      Patient
        Name
      Rank 1Rank 2Rank DifferenceSymptom Change
      bob smith1 better
      jill scott000no change
      mary heart63-3better
      joe rogan352worse