6 Replies Latest reply on May 5, 2016 1:08 PM by Ivan Young

    Max Year In if condition

    Vivek Sonawane

      hello all,

       

       

      i have created Parameter as

       

      [MaxYear]      ==>     Max(Year)

       

      now i want to use this max year like

       

       

      if year(Date) = [MaxYear] than sum([Amount]) end

       

      but the above calculation is not working

       

      please help to create condition which will change on selection,

       

      eg by default output will be max of year when user will select last year then that will be its max year 

       

      thanks