Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Percentage calculation in Report builder

Questions
Tags
Users
Badges
Nitin Kaushik
(11●2●19) Apr 05 '19, 4:23 a.m.

Can someone help me how can we calculate percentage of traced requirement in Report Builder. 

We have the scenario in which we need to calculate the percentage of number of customer requirement which have satisfied by link to system requirement. Is there a way to compute it using Report Builder .
Can someone point in the right direction to perform the same?

0 votes

4 answers
5,133 views
0 votes

4 answers

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) Apr 05 '19, 9:13 a.m.

 Start here: https://jazz.net/library/article/1493 I'd suggest to read all of it. The Calculated values is likely what you need. 

0 votes

Comments
Nitin Kaushik
Apr 11 '19, 7:35 a.m.

Yes I am able to calculate the percentage using the advanced function in repor builder. However it restricts the usage for run time selection of module/collection, project area etc.

 

Permanent link
smk developer
(11) edited
Oct 04 '21, 2:32 a.m.

 Will there ever be a situation where the total percentage is not 100%?  If not, then you could use the logical formula:

=Sum(Fields!Sales.Value,"Table1")/Sum(Fields!Sales.Value,"Table1") * 100

I know it sounds very simplistic, but if the total percentage will always be 100%, then you could either use this formula, or just hard code "100%" into that field.


For calculate Math percentage use - Percentage Calculator

0 votes

Permanent link
Wakas Khookhar
(11) edited
Dec 16 '24, 8:19 a.m.

if you want a quick and easy way to calculate your percentage, you can use an online tool like the CGPA to Percentage Calculator. Simply enter your CGPA, and it will automatically convert it into the percentage for you.

0 votes

Permanent link
Blair Manley
(11●1) edited
Dec 17 '24, 9:26 a.m.

Thank you for sharing this information...

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 481

Question asked: Apr 05 '19, 4:23 a.m.

Question was seen: 5,133 times

Last updated: Dec 17 '24, 9:26 a.m.

Confirmation Cancel Confirm