3 Replies Latest reply: Jan 22, 2016 3:34 PM by Stefan Wühl RSS

    Set Analysis Syntax Help

    Cassandra Baqir

      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