Set analysis range

[bobbydave]

I guess this is trivial but i am going nuts but can someone assist

I am trying to get a range between the last  3 months and today.

=sum({< YearMonth = {"'>=' & MonthStart(AddMonths(today(),-6)) & '<=' & MonthStart(AddMonths(Today()))"} >} Security_Total)

The range is confusing me when using within set analysis

[sunny_talwar · Accepted solution]

May be this

=Sum({<YearMonth = {"$(='>=' & MonthStart(Today(), -3) & '<=' & MonthStart(Today()))"}>} Security_Total)

[snehamahaveer]

Hi David,

May be you could try using this..

If you are specific with dates, then the one below.

Sum({<YearMonth = {'>=Addmonths(Today(),-3) <= Today()'}>}Security_Total)

if you want 3 months including the current month,

Sum({<YearMonth = {'>=Addmonths(Monthstart(Today()),-3) <=Monthstart(Today())'}>}Security_Total)

Hope it helps,

S