Set analysis

[#1]

Hi all, need help,

i have a set - COUNT({<StatusHistory.YearMonth = {">=$(=MonthStart(min(StatusHistory.YearMonth)))"}>}distinct SabID) , its counts sabid at month start and works fine, now i wan to count sabid of next month monthstart,

COUNT({<StatusHistory.YearMonth = {">=$(=MonthStart(min(StatusHistory.YearMonth),+1))"}>}distinct SabID) and its returs me 0..

please help

[#2]

>= MonthEnd instead of Monthstart+1

[MK_QSL]

COUNT({<StatusHistory.YearMonth = {'>=$(=MonthStart(AddMonths(min(StatusHistory.YearMonth),1))'}>}Distinct SabID)

[CELAMBARASAN]

What is the value format in YearMonth Field?

How you created this field?

[MK_QSL]

COUNT({<StatusHistory.YearMonth = {'>=$(=Date(MonthStart(Min(StatusHistory.Date),1),'MMM YYYY'))'}>}Distinct SabID)

Change 'MMM YYYY' according to your YearMonth format... i.e. YYYY MMM or YY MMM

[#6]

its still return my 0...

[PrashantSangle]

Hi,

I am just modifying  your set analysis because it is almost close.

COUNT({<StatusHistory.YearMonth = {">=$(=MonthStart(AddMonths(min(StatusHistory.YearMonth),+1)))"}>}distinct SabID)

Regards,

[#8]

thanks for set analysis, but i still get 0.. there is 2 pics, firs what i get now, and secont what i need:

[MK_QSL]

It will be better if you load your sample apps or sample data file.

[#10]

its impossible, apps ~600mb...