I have a question about using cross report calculations. I've read the documentation regarding this which states:
Key-figures can be referenced across reports using the syntax:
[[//keyfigurename@DAI:report_right_Id//]]
Example:
To retrieve the current result of the key-figure “Total contribution ratio” on report 1234:
[[//Total contribution ratio@DAI:1234//]]
Is the following interpretation and understanding of what I can do with this correct?
Report "Job Change Order Total" totals the price for all change orders selected for a single job number according to the supplied filter value. A key figure named 'Total Change Orders' is defined in this report based on the column total for [[Price_Est]].
- Change_Order_Rpt.gif (4.73 KiB) Viewed 7495 times
Report "Job Cost Report" that also selects data based on a single job number value defines a key figure called: 'Billable Change Orders' and its formula is: [[//Total Change Orders@DAI:1846//]]
When I run the Job Cost Report it seems to display a consistent, random value for billable change orders. Consistent because its the same total no matter what job number I filter on; random because I don't know what set of records its reading to generate that number. For example running the change order report for job 215322 yields a total of 10,821.60. But the key figure in the job cost report for the same job number shows the total as $24,085.
- Job_Cost_Rpt.gif (18.16 KiB) Viewed 7495 times
Thinking the correct job numbe filter value was not being passed, I defined a relation between the two data sources used by these two reports on job number but that didn't make any difference.
Clearly I'm not fully understanding how cross report calculations are intended to be used or I am doing something wrong. I didn't find any mention of additional requirements in the docs.
Any help is appreciated.
Regards,
Bob
