2 Replies Latest reply on Mar 27, 2018 5:13 AM by Jim Dehner

    Cannot mix aggregate and non aggregate comparisons or results in IF expressions

    Amit Darak

      IF [Date] <= TODAY()

      and DATEDIFF('year', [Date], TODAY()) = 0

      THEN [Cash_Brokerage_Net]

      END

       

       

      Cash_Brokerage_Net is a calculated field.

       

      How do I solve this error?