Welcome to the Jazz Community Forum
How to calculate percentages using Jazz Reporting Service advanced option
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.