Distinct business days count in specified month

[Anonymous]

Hi All,

        We have a data model like below:

CALENDAR_DATE	MOST_RECENT_BUSINESS_DATE
12/1/2012	11/30/2012
12/2/2012	11/30/2012
12/3/2012	12/3/2012
12/4/2012	12/4/2012

When we are doing Count(distinct (MOST_RECENT_BUSINESS_DATE)) then we are getting 3 number but asper my requirement we want to get only  2 since 11/30 is the date from last month.

Can you guys help me constructing correct expression to get this data?.

QVW has been attached..

[swuehl · Accepted solution]

Maybe like

=count(DISTINCT if(month(MOST_RECENT_BUSINESS_DATE)=month(CALENDAR_DATE), MOST_RECENT_BUSINESS_DATE))

or have a look at the NetWorkdays() function in QV help, which might calculate the number you need.