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

      Hi,

      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'

      END

       

      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