cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

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

Chittaranjan_11
14-Alexandrite

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

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.
0 REPLIES 0
Announcements


Top Tags