It's all about the answers!

Ask a question

Create a decimal


Yorai Oz (15118) | asked Apr 26, 12:54 p.m.

Hello all!


I am using JRS report builder SQLand I have created a count using custom expressions.
COUNT DISTINCT CASE WHEN and the query result round the result (57). I would like it to be with the decimal (i.e 189/328=0.57), or to present the percentage (%) value sign next to the value. How do I do that?

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.