Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to display a text box that shows a count of REQUEST_ID where CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design' and where sum(WORKFLOW_DURATION)>=120. Thesum(WORKFLOW_DURATION) should just refer to WORKFLOW_DURATION for 'Project Initiation and Design. I keep getting an error. What am I doing wrong?
=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design',sum(WORKFLOW_DURATION)={">=$(>=120)"}>}REQUEST_ID)
Thanks,
Cassandra
try with this
=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design'},REQUEST_ID ={"=sum(WORKFLOW_DURATION)>=120"}>}REQUEST_ID)
try with this
=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design'},REQUEST_ID ={"=sum(WORKFLOW_DURATION)>=120"}>}REQUEST_ID)
You can't use the Sum function directly in place of field.
Try like below:
=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design', REQUEST_ID={"=sum(WORKFLOW_DURATION)>120"}>}REQUEST_ID)
I assume you want to sum() per Request_ID:
=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design', REQUEST_ID = {"=sum(WORKFLOW_DURATION)>=120)"}>}REQUEST_ID)