Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone please help me get this in the right syntax?
=count({$<DETECT_DATE= {"<=$(vDefectStart) and >=$(vDefectEnd)"}*e( {1< PRIMARY_DECISION_BODY ={'SMG Committee'}) >}distinct DEFECT_ID)
DEFECT_STATUS={'New'} should not be needed anymore since we are identifying a New ticket by the DETEC_DATE and DEFECT_STATUS_START_DATE={"<=$(=AddMonths(Today(),-6))"}>} is when it was rolling 6 months and should be DETECT_DATE is BEFORE the selected date range...
But, this is not returning anything:
=Count({$<DEFECT_ID=P({<CUR_STATUS = {'Closed'},CLOSE_DATE={">=$(vDefectStart)<=$(vDefectEnd)"},DETECT_DATE={"<$(vDefectStart)"}>})
*E({< PRIMARY_DECISION_BODY ={'SMG Committee'}>})>}DISTINCT DEFECT_ID)
There are no records with these conditions.
Then I explained it wrong. There should be 522. Here are the requirements:
=Count({$<CUR_STATUS = {'Closed'},DEFECT_ID=P({<CLOSE_DATE={">=$(vDefectStart)<=$(vDefectEnd)"},DETECT_DATE={"<$(vDefectStart)"}>})*E({< PRIMARY_DECISION_BODY ={'SMG Committee'}>})>}DISTINCT DEFECT_ID)
Try this?
=Count({$< DEFECT_ID = P({< CUR_STATUS = {'Closed'},
CLOSE_DATE = {">=$(vDefectStart)<=$(vDefectEnd)"},
DETECT_DATE= {"<$(vDefectStart)"}>})
*
E({1< PRIMARY_DECISION_BODY ={'SMG Committee'}>})>}DISTINCT DEFECT_ID)
Does not return anything.
Clear the selections from current selection box and try.
It seems to work.
It doesn't seem to be responsive to my calendar variables?
Nor does it work in the table chart.
Shouldn't there be variable dates in the current selections? Why would it work when those are cleared?