It's all about the answers!

Ask a question

Custom Expressions or SQL query example for JRS Reports


Amit Garg (312051) | asked Jun 17 '19, 5:35 a.m.

We are using CLM 6.0.5 and creating some JRS reports which requires some calculations. However, we did not find enough documentation on how the custom expressions work in JRS.


We have a requirement where we want to show calculations based on a formula for ex (1 - Implemented Stories/Committed stories) 
where the implemented stories shows number of closed stories and committed stories are the total number of planned stories.

How to use a custom expression $Work Item:Planned For$ for achieving (Sprint 2 - Sprint 1)

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.