1 Reply Latest reply on Oct 29, 2018 7:57 AM by Mark Fraser

    IF Statement help with error

    jamie.brown.0

      I need some help with the below calculation. I am getting an error message of "cannot mix aggregate and non aggregate with this function". The formula gives the error when I include the [measure] section. Any ideas on how to fix this?

       

      IF AVG([Goal]) >  [Percentage] then "Met"

      Elseif AVG([Goal]) < [Percentage] AND [Measure] = "Poor Control" THEN "Measure Met"

      ELSE "Not Met"

      END