AnsweredAssumed Answered

Conditional Calculation on related tables

Question asked by AlexandrosKaralakis on Sep 5, 2014
Latest reply on Sep 8, 2014 by AlexandrosKaralakis

Title

Conditional Calculation on related tables

Post

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 ?

Outcomes