Conditional Calculation on related tables
Sorry, if this type of thread has been answered before, but i checked previous threads and i gor confused.
I have two tables.
Table1 with fields: ID, Year, Quarter, Forecast Indicator, Date1, Date2, Date1 minus Date2, Number1, Number2, etc...
Table2 is related to Table1 on the fields: ID, Year, Quarter, Forecast Indicator
On Table2 there are some other fields that calculate min, max, average from the related Table1. I want to duplicate those fields but instead to show results only if "Date1 minus Date2" from Table1 is less the 30 days.
e.g. Min field on Table2 is calculated like this: Min (Table1::Number1). Is there anyway to change this formula and add if statement to calculate the Min only for Table1::Date1 minus Date2 < 30 ?