5 Replies Latest reply on Oct 6, 2016 2:36 PM by Erdem Yazganoglu

    Error - Cannot mix aggregate and non-aggregate arguments with this function

    Erdem Yazganoglu


      I know this error was discussed a lot in the past and I went through these and unable to find a solution to my problem.


      I am getting above error with the following formula


      IF ((([Indexed to Island Health] < 0.9) and ( [Good_when]= 1)) OR (([Indexed to Island Health] > 1.1) and ( [Good_when] = 2))) then 'bad'

      ELSEIF ((([Indexed to Island Health] < 0.9) and ( [Good_when] = 2)) OR (([Indexed to Island Health] > 1.1) and ( [Good_when] = 1))) then 'good'

      else 'not different'



      Index to Island Health is calculated as follows:


      1+((sum([Value])-SUM([Value (BC)]))/SUM([Value (BC)]))


      here is what I tried.


      I created a new field from Good_when using aggregation ATTR [Good_When], it resolved the calculation error but it was unable to calculate the groups accurately. All results drop in to "indifferent" category.


      Any suggestions?


      Thank you in advance