1 Reply Latest reply on Feb 12, 2019 9:21 AM by Paul Wachtler

    Calculation to combine fields




      I am trying to combine the highlighted fields in classification column with the surgery name column. Is there a way to combine certain fields with other columns?

        • 1. Re: Calculation to combine fields
          Paul Wachtler

          Hi Hina,


          To simply join the two fields you could use:

          [Surgery Name] + " " + [Classification]


          If you want to only use it for certain surgeries or classifications you could do something like this:


          if [Classification] = "ANTERIOR CERVICAL ARTIFICIAL DISC" or [Classification] = "CHIARI MALFORMATION" or (fill in the rest of the if statements here)

          then [Surgery Name] + " " + [Classification]