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

[MK_QSL]

You can definitely create dummy data say 10-20 lines in excel file..

[PrashantSangle]

Hi,

Actually there is very small mistake

try this,

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

MonthStart() returns complete date like 1-5-2013

but you StatusHistory.YearMonth is in format of Kov 2010 i.e (Mar 2010)

therefore you have convert above expression using Monthname()

Hope this will help you,

Regards,

[#4]

attached to my firs post on top

[PrashantSangle]

Hi,

Is this solution work???

[PrashantSangle]

Hi,

Did you try my solution??

[#7]

I missed yours replay, sorry.. but yours solution not work..

[#8]

count({<StatusHistory.YearMonth={">=$(=addmonths(monthstart(min(StatusHistory.YearMonth)),1)"}>}distinct SabID)

[CELAMBARASAN]

I'm guessing, if you provide how the YearMonth field is created. well that gives clear idea solve your problem.

Regards,

Celambarsan