Set Analysis Syntax Help

[cbaqir]

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

[ramoncova06 · Accepted solution]

try with this

=Count(distinct {$<CUR_WORKFLOW_STEP_NAME={'Project Initiation and Design'},REQUEST_ID ={"=sum(WORKFLOW_DURATION)>=120"}>}REQUEST_ID)

[#3]

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)

[swuehl]

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)