JRS Report Builder v6.0.2 DB2 SQL Percentage Conversion of Actual_Work divided by Planned_Work does not work
CLM v6.0.2
SELECT DISTINCT
ELSE .22 END AS Percentage,
CASE WHEN T1.ACTUAL_WORK > 0 THEN -- This Case shows that it is getting inside the case and performing the calculation on the Decimals
FROM RIDW.VW_REQUEST T1
this question will not allow me to insert a picture of my results...Anyway Time Spent = 8.00 Estimated = 12.00 Variance = 4.00 Percentage = 0% Test_Percentage = 66.7% Test_Decimal1 = 8.00 Test_Decimal2 = 12.00
basically I am getting into the case statement, I can obtain the values, but for some reason the values (T1.ACTUAL_WORK/3600.0)/(T1.PLANNED_WORK/3600.0) (Percentage) will not divide to give me the percentage I need to display instead it gives me 0% although I can use 8.00/12.00 and it works (Test_Percentage) and gives me 66.7% |
2 answers
Answer from IBM Support: Use a Double and check for both Actual and Planned
SELECT DISTINCT
|
Don't go like this but you can modify the query as per your requirement. I have implemented the same type of report in BIRT and is working perfectly.
|
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.