5 Replies Latest reply on Aug 13, 2018 8:18 AM by priti.shah.0

    Error: Cannot mix Aggregate and non aggregate comparison in if expressions

    priti.shah.0

      Hi,

      I'm trying to get this formula work but I'm getting

      Error: Cannot mix Aggregate and non aggregate comparison in if expressions

      If Acct type is "R" then Actual - Budget else Budget - Actual.

       

      (If [Actual Flag]="A" THEN

      (IF [Account Type]= "R" THEN SUM([RR-CM Actual])-SUM([RR-CM Budget]) ELSE SUM([RR-CM Budget])-SUM([RR-CM Actual]) END)

      END)

      Please guide. Thanks.

      -Priti