Set analysis to get data for the previous month from date selection

[tinkerz1]

Hi,

How do get to a previous months set of data using set analysis?

If I have one selection of month logged with a date of 11/2016, I need data from 10/2016 to make % change

I have made 2 text boxes confirming the calculations bring back the correct numbers

num(date(floor(Addmonths([MonthLogged],-1)),'DD/MM/YYYY'))

num([MonthLogged])

But my set analysis fails to make a between statement

count({$<[Table]={'Open_Balance'},MonthLogged={">=$(=num(date(floor(Addmonths([MonthLogged],-1)),'DD/MM/YYYY')))<$(=num([MonthLogged]))"}>} %KEY_CaseIDR5_Open_Balance)

Where am I going wrong?

Thanks

[vishsaggi]

Reference from Sunny's set analysis expression with regards to set analysis dates, Try this?

= count(

             { $< [Table]={'Open_Balance'},

              MonthLogged ={"$(= '>=' & num(date(floor(Addmonths([MonthLogged],-1)),'DD/MM/YYYY'))) & '<' &                               num([MonthLogged]))"} >}

              %KEY_CaseIDR5_Open_Balance

           )

[muthukumar77]

Hi,

I hope it will be useful.

PFA

[everest226]

= count(   { $< [Table]={'Open_Balance'},MonthLogged ={"$(= '>=' & num(date(floor(Addmonths([MonthLogged],-1)),'DD/MM/YYYY'))) & '<' &  num([MonthLogged]))"} >}

              %KEY_CaseIDR5_Open_Balance

           )