1 Reply Latest reply: May 5, 2015 9:47 AM by andy whitfield RSS

    Last Months Activity

      Hi all,


      I'm trying to write a formula to just bring through last months activity, ive tried using the formula but with no joy.


      Anyone have any ideas as to how I could alter this to bring through just last months data?



      ·         =SUM({<Metric_Code “RTT9”={">=$(=MonthStart(Today(),-1)) <=$(=MonthEnd(Today(),-1))"}>} Metric_Value)



      mMany thanks in advance,