1 2 Previous Next 16 Replies Latest reply on Apr 19, 2015 10:04 PM by Dearnne Deaves

    Cannot mix aggregate and non-aggregate comparisons error...

    Dearnne Deaves

      Hi,

       

      Does anyone know how to fix this formula to remove the error: "Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions"

       

      IF

      ATTR([Month]) = [Current Month]

      THEN

      [Measure Value]

      END

       

      where [Current Month} = MAX([Month])

       

       

      I have a dataset containing values of specific items over the past 12 months. I was to create a calculated field containing the value of the most recent month  so I can use this at a later stage.

       

      Thanks,


      Dearnne

        1 2 Previous Next