AnsweredAssumed Answered

Calculation field between two records in a related table

Question asked by gregdc on Jun 27, 2014
Latest reply on Jul 1, 2014 by gregdc

Title

Calculation field between two records in a related table

Post

     Using FMP 13 Advanced:

     Two tables

     Organization -------------------<   Scorecard

     PKOrgID                                        FKOrgID

     DifOfLastTwoYears                    ScorecardYear

                                                             Score 

      

     DifOfLastTwoYears  = Score of largest ScorecardYear - Score of next smallest ScorecardYear

      

     I need help creating the Calculation for DifOfLastTwoYears field in Organization

      

     Example data:

     FKOrgId                     01           01         01

     ScorecardYear    2012          2010   2009

     Score                        20             18        16

     DifOfLastTwoYears should be 2.    

     Can this even be done?

Outcomes