1 Reply Latest reply on Dec 19, 2015 1:41 AM by Elliott Stam

    how to fix this formula to remove the error: "Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions"

    siva goberu

      Hi,

      how to fix this formula to remove the error: "Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions"

       

       

      IF  DATEDIFF('day', [End Dates], [Dates]) = -1

      then  ([Daily - Spend - Target])

      else null

      End

       

      Please can u help me on this.

      Regards,

      Siva G