4 Replies Latest reply on Oct 11, 2012 12:05 PM by Michael Nealey

    If statement with conditions

    Michael Nealey

      I'm pretty certain a fix to this problem is possible.


      I'd like to create a calculation that allows me to say:


      IF [Dimension] = "X"

      AND [Measure] <=n

      THEN "Improve"

      ELSE "Promote"

      But if [Dimension] = "Y"

      AND [Measure] >=N

      THEN "Fix"

      ELSE "Monitor"


      Any thoughts?