1 Reply Latest reply: May 5, 2015 9:47 AM by Andrew 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,

       

      Nick