Calculation Field Based on a Subset of Records
Creating a calculation field based on all the records from a related table is, of course, a very simple matter. Question: Is it possible to create another calculation field based on a subset of those related records? For example, a calculation field for the hours-worked during the month of October from a table that contains the hours-worked for the entire year. If possible, what does the formula look like when the calculated field is defined?