Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The set analysis below is not ignoring selections. Is there something I'm missing in the syntax to ignore selections?
These are the variable definitions: vGapStart =MonthStart(CurrentMonth-1)-3 and vGapEnd = MonthStart(CurrentMonth -1).
Set Analysis:
count({1<
Name = E( {1< PtStatus = {'IN','INO'} > + 1< DischargeDispositionID = {'AMA','LWBS'} >} )
,ErServiceDateTime = {"= date(ErServiceDateTime,'M/DD/YYYY') > date(vGapStart,'M/DD/YYYY') and date(ErServiceDateTime,'M/DD/YYYY') < date(vGapEnd,'M/DD/YYYY')"}
,ReadmittedWithin3Days = {'Y'}
>}Name)
May be this
count({1< Name = E( {1< PtStatus = {'IN','INO'} > + 1< DischargeDispositionID = {'AMA','LWBS'} >} ) ,ErServiceDateTime = {"= date(Only({1} ErServiceDateTime), 'M/DD/YYYY') > date(Only({1} vGapStart), 'M/DD/YYYY') and date(Only({1} ErServiceDateTime), 'M/DD/YYYY') < date(Only({1} vGapEnd), 'M/DD/YYYY')"} ,ReadmittedWithin3Days = {'Y'} >} Name)