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!!