Last Months Activity

[#1]

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

[awhitfield]

Hi Nick,

check this one out!

https://community.qlik.com/docs/DOC-4313

Andy