Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to calculate Planned Work - Actual Work (from RTC) using Custom Expression in Jazz Reporting Service 6.0.6

 Hello,
I have an older (6.0.3) Jazz Reporting Service report that used the advanced features to calculate Planned Work minus (-) Actual Work.  It worked fine, but the report couldn't be modified in the RTC dashboard widgets due to using the advanced feature.  We recently upgraded to Jazz 6.0.6 and finally have access to Custom Expressions in the report builder which is supposed to provide more capabilities without having to use the advanced features in the reporting service.  My question is how can I achieve a calculation of two integers using the Custom Expression without having to use the advanced capability?
For example:
Old Way Using Advanced...

 SUM(T1.PLANNED_WORK-T1.ACTUAL_WORK)/3600.00 AS REMAINING_WORK 
New Way Using Custom Expression....
????????
Let me know if this is even possible with the Custom Expression.
I appreciate any and all responses and thank you for your time in advance.  
This is where I need help, guidance, or

1

0 votes

Comments

ANY answer is greatly appreciated!! 



One answer

Permanent link

Hi Kyle,

I don't have an answer, but I'm trying to do the same thing. Did you come up with a solution? Thanks for any help you can provide.

0 votes

Your answer

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

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,023
× 7,499

Question asked: Jun 27 '19, 8:48 p.m.

Question was seen: 2,728 times

Last updated: Sep 11 '20, 4:47 p.m.

Confirmation Cancel Confirm