4 Replies Latest reply: Dec 8, 2016 5:20 AM by Sunny Talwar RSS

    Previous year expression in not working in Sense

    vijay prasad

      Hi All,

       

      This expression is not working in QVSense

       

      (Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)}, Quarter=

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

      >} [ Sales ])