1 Reply Latest reply: Nov 9, 2018 3:43 PM by Stefan Wühl RSS

    Help with Date Expression Set Analysis

    Antonio Domingos

      Hi Guys!,


      I have a number field called DATA_BASE_FINAL on format YYYYMM.


      I'm using a expression for my dimension =date(date#(Max(DATA_BASE_FINAL),'YYYYMM'),'MMM/YY') and returns me the date Oct/18 correctly.


      But I'm trying to put it on my set analysis this way  =SUM({<DATA_BASE_FINAL={"$(=date(date#(Max(DATA_BASE_FINAL),'YYYYMM'),'MMM/YY'))"}>}SDB_ATUAL)/1000000 and does not work.

      Have a problem with my expression?



      Tks all!!