3 Replies Latest reply: Sep 25, 2018 7:18 AM by omar bensalem RSS

    Date from filter

    Del Booth



      I have a date filter called ColMonth (Jan, Feb, Mar....Dec) and use it to generate a table for different months.  I want to compare two months a selected one and the previous ie Select March and compare it with February.


      I have tried using ColMonth = Colmonth-1 in a set analysis but it does not work, I have tried


      month(makedate(ColYear, ColMonth-1))  on its own and it goes me the the month 2 but when used in a set expression it does not work,