4 Replies Latest reply: Jan 29, 2018 10:50 AM by Juan Moreno RSS

    YearMonth in Set Analysis

    Juan Moreno



      In an expression I'm writing I want to consider only those records corresponding to last month. I have a calendar with the variable link_YearMonth that takes values such as 2018-01, 2017-12, etc.


      I wanted to use Set Analysis in the following manner:




      The complete expression looks like this:





      Whenever I add that YearMonth condition in bold, the expression returns zero. Do you see any problem in using it? Is there any alternative condition I can use to restrict the values to last month?