1 Reply Latest reply on Nov 13, 2018 4:02 AM by Zhouyi Zhang

    MTD Last year with two parameter by checking the today's date

    Nandha Kumar Murugesan

      I want to check the current selected parameter and year

      then if if equals to current selected parameter and year  then for last year MTD also select till yesterday data

       

      Eg for current lets consider november 2018 (today's date as 13) is selected

      then the current data should be selected till novemeber 12 and MTD last year also should be selected till november 12 2017 for comparison

       

      (NO filter only using the parameter )

       

      I tried multiple if but nothing seems working  for comparing the if class with the today month and year with the parameter selected.

       

      [This data i tweaked to use the year 2015 as 2018 for getting the required fields]