5 Replies Latest reply on Oct 1, 2013 8:38 AM by . Indumon

    min date function, error with aggregate/non aggregate

    caroline ennis

      I have a mix of dates and values, and I would really like to view the smallest date that is greater than another date in the table. When I add a calculated field that reads like this:

       

      MIN([DEPT EFFECTIVE DATE]) > ROLE_EFFDT

       

      But I get the error regarding not mixing aggregate and non aggregate values. What can I do?