I have two tables that matter:
I have made a layout based on the Results table. In this table I would like to show summaries of fields from the Expectations table such as Expectations::gross_income
I have done the following:
- Related the two tables with the fund field that is present and populated in both tables. Expectations::fund = Results::fund
- Created the calc field Expectations::gross_income_total with the following calculations field: sum ( gross_income )
- Added the field to the layout based on the Results table, now the field displays <index missing>
What am I doing wrong?
The layout is to be filtered by the fund field to only show results for a specific result, when this is done, I would like the expectations summary field to be about that fund only as well.
What approach would I use?