Skip to main content
14-Alexandrite
October 26, 2020
Question

How to display a count of Requirements having no "Assigned User" assigned in Report with Computation

  • October 26, 2020
  • 0 replies
  • 794 views

Hello Team,

 

I wanted a count of such Requirements having no "Assigned User" added, this count to be display in Report as per Requirement Document.

Note; This to be achieve without creating any new fields

 

I have got workaround with creating 2 new integer computation fields

Examples,

1) 2 Computation fields
    a) Test_Field_status [ SelectionCount("Assigned User")==0?0:1 
    b) Test_Field_count [ "Test_Field_status"=1?1:0 ]
2) Create a Query for Report: Test_Count Query
3) Create a Report
Report Type: ALM_Basic - HTML, Column, One Grouping, Field Compute with ALM 2009 CSS
Report Query:  Test_Count Query
Computation in Report: "Test_Field_status"==0
 
Let me know if there workaround without creating new fields and display the Null Assigned User Requirements count.