Calculated reports using RRDI
I am trying to create a customized report in RRDI by pulling RTC data. By joining few queries, I am able get the data in the format below:
| Customer Name | Workitem state | Amount |
| ABC Ltd | Fund Released | 500000 |
| ABC Ltd | Fund Released | 400000 |
| ABC Ltd | Fund acknowledged | 200000 |
| ABC Ltd | Fund acknowledged | 300000 |
| XYZ Ltd | Fund Released | 150000 |
| XYZ Ltd | Fund Released | 300000 |
In the above table, customer name and amount are the custom attributes and workitem state is a inbuilt attribute in RTC. These states are well defined in the workflow.
Based on the above data I want to generate a report:
| Customer Name | Total Fund Released | Total Fund acknowledged | Fund released but not acknowledged |
| ABC Ltd. | 1400000 | 500000 | 900000 |
| XYZ Ltd. | 450000 | 0 |
450000
|
Formulae used for the figures in the respective columns are as follows:
Total Fund released = Total of Amount column based on the customer name column.
Total Fund acknowledged = Total of Amount column based on workitem state and customer name column.
Fund acknowledged but not released = Total Fund released - Total fund acknowledged.
I want to generate this report (2nd table) automatically based on the data in (1st table).
Comments
Seth Packham
FORUM ADMINISTRATOR / JAZZ DEVELOPER Jun 06 '12, 10:39 a.m.Please edit your question to be in the form of a specific question, and edit the description to be readable. You pasted HTML that is unreadable.
Naveen Chandani
Jun 14 '12, 3:33 a.m.I guess now it is in the readable format. Could you please help me with the query