Previous months figures

[shamitshah]

Hi,

I am trying to get the previous months figures based on reference to today's date in a text object, but it comes up with an error message.

Any ideas?

Thanks

[techvarun · Accepted solution]

Please try the below set analysis

= sum({<MonthYear = {"$(=Date(MonthStart(Today())-1,'MM-YY'))"}>} Actual)

[shamitshah]

Thanks Varun,

That worked out quite well.