0 Replies Latest reply: May 3, 2017 7:10 AM by P M RSS

    Expression is not working in Sense

    P M

      Dear All,

       

      I have one set expression which is not working in Sense

       

      SUM({$<FinancialYear=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)} ,

      [Posting Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))"}

      >}[Sales])

       

      Can anyone help me out.

       

      Thanks