It's all about the answers!

Ask a question

How to calculate percentages using Jazz Reporting Service advanced option


Ahmed Ahmed (48732) | asked Aug 26 '16, 10:50 a.m.
 
Hi,

Is it possible in JRS that we can calculate percentages. For example , i want to create the report based on the following formula:

Total No. of open Tasks / Total no tasks * 100

Let suppose Total no. of open tasks are 5 and total no tasks are 15. Now as per the above formula the result should be 33.33%

I have calculated the count of all the tasks. Now when i going to apply the above formula in SQL query of JRS i am getting the answer of 33. In query i have used the cast function to convert the values into decimal but still i am not getting the required result. Now my question is, whether JRS supports the conversion functions or not. How can i generate the report in JRS which shows the percentages. 

Be the first one to answer this question!


Register or 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.