4 Replies Latest reply: Feb 14, 2017 2:36 PM by ilan baruch RSS

    Set Analysis - Addmonths

    ilan baruch

      Hi all

      i have an expression with AddMonths in Set Analysis (below)

      working fine with Today() as date but when trying to connect to model Date Field both expressions retrieve same value

       

      any ideas?

       

       

       

      SUM({<YYYYMM={"$(='>=' & date(AddMonths(Max(DATE),-3),'YYYYMM'))"}>}AMOUNT)

      //SUM({<YYYYMM={"$(='>=' & date(AddMonths(Max(DATE),-1),'YYYYMM'))"}>}AMOUNT)