Count of IDs on this month but not last month

[Anonymous]

Hi,

I am trying to ascertain how many IDs were on a report in Jan but not on the report in Feb.  I have had a couple of attempts with Set Analysis but hitting a brick wall:  Current Set Analysis Used:

COUNT(DISTINCT{<BSEG_DT -={">=$(=MonthStart(Today(),-2)) <=$(=MonthEnd(Today(),-2))"},
BSEG_DT ={">=$(=MonthStart(Today(),-3)) <=$(=MonthEnd(Today(),-3))"}>}SA_ID)

But this just returns the total amount of IDs on the jan report.

Any ideas where I'm going wrong?

Cheers,

[sunny_talwar · Accepted solution]

May be try this

Count(DISTINCT {<SA_ID = p({<BSEG_DT ={">=$(=MonthStart(Today(),-3)) <=$(=MonthEnd(Today(),-3))"}>}) - p({<BSEG_DT ={">=$(=MonthStart(Today(),-2)) <=$(=MonthEnd(Today(),-2))"}>})>} SA_ID)

[Anonymous]

Perfect Sunny.

Cheers Bud.