1 Reply Latest reply on Nov 19, 2012 9:21 AM by Tracy Rodgers

    How can I have multiple calculations/lines in 1 calculated field.

    James Kucher

      In a calculated field named Outcome,  I have would like to have the following calculation.  I'm refering another dimension that has a string and using 4 boolean parameters.  Is it possible to have multiple lines of code?  If so what syntax am I missing?

       

      [Close]=Contains([System status],"TECO")=True

      [Complete]=Contains([System status],"CNF")=True

      [Not Active]=OR([Close],[Complete])=True

      [Active]=Not([Not Active])

      If(Active=True,"Active",IF(Complete=True,"Complete","Close"))