2 Replies Latest reply on Jul 24, 2018 7:12 PM by Zhouyi Zhang

    Workaround for mixing aggregate and non aggregate functions in Date Diff Formula

    Anna Chan

      Hi I am trying to create formula to show the first 7 days of a given time period. I tried the the data diff formula but i cannot use the min function in that. Is there a workaround. My formula is listed below.

      DATEDIFF('day',min([date]),[date]) =7

      ERROR: Cannot Mix aggregate and non aggregate formulas.