Unable the get the count in set expression...

[#1]

Hi Team,

Please suggest as what is causing the problems in the below expression where im trying the caluclate the count of all till prev date(excluding few types[Status Desc]) + the current date (excluding few types[Status Desc])

fabs

(count({$<STATUS_DESC-={'Resolved','Standby provided','Cancelled','Under Observation'},REGION={'EAST','WN-EAST'},
INCIDENT_DATE={"=$(=date(daystart((INCIDENT_DATE))))+(>=$(=daystart(MAX(INCIDENT_DATE))))"}>}IN_INCIDENT_NO))

INCIDENT_DATE format is MMDDYYYYHHMMSS

Please help by suggesting your thoughts of improments in the above exp...

Thanks,

Hassan

[#2]

Hi,

Try this

(count({$<STATUS_DESC-={'Resolved','Standby provided','Cancelled','Under Observation'},REGION={'EAST','WN-EAST'},
INCIDENT_DATE={"=$(=date(daystart([INCIDENT_DATE])))+(>=$(=daystart(MAX([INCIDENT_DATE]))))"}>}IN_INCIDENT_NO))

[#3]

Try This...........

count({$<STATUS_DESC={"*"}-{'Resolved','Standby provided','Cancelled','Under Observation'},REGION={'EAST','WN-EAST'},
INCIDENT_DATE={">=$(=Date(daystart(vMaxDate)))<=$(=Date(floor(DayEnd(vMaxDate))))"}>}IN_INCIDENT_NO))

vMaxDate=Date(max(INCIDENT_DATE),'MMDDYYYYHHMMSS')

[#4]

  not helping...please correct if there is some problem in the below expression...

fabs

(count({$<STATUS_DESC={'*'}-{'Resolved','Standby provided','Cancelled','Under Observation'},REGION={'EAST','WN-EAST'},
INCIDENT_DATE={"=$(=DATE(daystart(max(INCIDENT_DATE))-1,'MMDDYYYYHHMMSS'))"}>}IN_INCIDENT_NO))

[#5]

any advises??please suggest

[Gysbert_Wassenaar]

Explain what INCIDENT_DATE={"=$(=date(daystart((INCIDENT_DATE))))+(>=$(=daystart(MAX(INCIDENT_DATE))))"} is supposed to mean. And post a sample document with some data that should be used for the calculations and also show what the result should be.