8 Replies Latest reply on Dec 28, 2016 9:34 AM by Patrick A Van Der Hyde

    filter on current year

    Vibhu Sharma

      Hi,

      I have [Year] column available in database and I want to filter chart based on current year

      I created calculated field CY=max([Year]) for calculating current year

      I am trying to create calculated filter based on below condition but I am getting error "Cannot mix aggregate and non-aggregate arguments to function"

       

      If [Year]=[CY] then 'True' Else 'False' End