9 Replies Latest reply on Nov 28, 2018 8:02 AM by Amar Amar

    How to fix Cannot Mix aggregates and non aggregates

    Amar Amar

      IF [YEAR ID]= 1 THEN  [% Metric] else 0 END


      this is giving me ...cannot mix aggregates and non aggregates error. I tried MIN([YEAR ID]) which is ok , but i need to do current year and previous year  in that case...MIN([YEAR ID]) will not work since MIN([YEAR ID]) will always show for example 1.




      Please advice.


      I'm trying to get correct numbers for current year and previous year.