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)
Check this attached?
What are you trying to count?. I can see that date variables was wrong... Try this and let me know if it works
=count({$<DETECT_DATE= {'>=$(vDefectEnd)<=$(vDefectStart)'}*e( {1< PRIMARY_DECISION_BODY ={'SMG Committee'}) >}distinct DEFECT_ID)
trying to count Distinct DEFECT_ID... the expression says okay but the result says Error in set modifier function set
=count({$<DETECT_DATE= {">=$(vDefectStart)<=$(vDefectEnd)"}, PRIMARY_DECISION_BODY -={'SMG Committee'}>}distinct DEFECT_ID)
Try this:
=count({$<DETECT_DATE= {'<=$(= $(vDefectStart) >= $(vDefectEnd))' } * e( {1< PRIMARY_DECISION_BODY ={'SMG Committee'}) >}distinct DEFECT_ID)
Try like:
=count({$<DETECT_DATE= {"<=$(vDefectStart) >=$(vDefectEnd)"} , e( {1< PRIMARY_DECISION_BODY ={'SMG Committee'}>})>} distinct DEFECT_ID)
OR
=count({$<DETECT_DATE= {"<=$(vDefectStart) >=$(vDefectEnd)"}> *<e( {1< PRIMARY_DECISION_BODY ={'SMG Committee'}>})>}distinct DEFECT_ID)
Note: 'and' removed and changes made in red (corrections in brackets, comma..). If your variable producing right output in right format, it should work.
error
error in expression
This returns a number but it's lower (1027) than I expected (1331). I will look into it. Thanks!
Try this:
= count(
{<
DETECT_DATE= {"$(= '>=' & $(vDefectStart) & '>=' & $(vDefectEnd))" }> * < e({1< PRIMARY_DECISION_BODY = {'SMG Committee'} >} )
>}
DISTINCT DEFECT_ID
)
IF doesn't work can you share your sample to look into please!!!