15 Replies Latest reply: Jun 1, 2016 6:42 AM by Андрей Шепель RSS

    Date functions in search filter in expression

    Андрей Шепель

      Good day!

      Colleagues, i'll try to describe problem which i have in calculating expr with search filter.

       

      1. I have main simple table with YearMonth field and DeliveryPoint

      2. Then i make one test independent field YearMonth_Test resident main table

       

      Then in pivot report i try to calculate count DeliveryPoint by YearMonth_Test dimension with such condition:

      Get count DeliveryPoint  for YearMonth=YearMonth_Test-1.

      For this case i set formula which get previous YearMonth from YearMonth_Test:


      Year(AddMonths( date#(YearMonth_Temp,'YYYYMM'),-1))&num(Month(AddMonths( date#(YearMonth_Temp,'YYYYMM'),-1)),'00' )

      But using this formula insight search expr filter doesn't work.

       

      My necessary result:

       

       

      YearMonth_TestCount
      20150431
      20150532
      20150626
      20150717

       

      If any idea to solve it, will be very glad.

      Thanks.