AnsweredAssumed Answered

Calculated field 'sometimes' not calculating ....?

Question asked by synergy46 on Sep 22, 2012
Latest reply on Sep 26, 2012 by synergy46

Title

Calculated field 'sometimes' not calculating ....?

Post


     I am using FM 12 Advanced on OSX

     I have a 1 to many application where Members (the one) is related to Dues (the many).  On a Members layout there is a dues portal.  One field on the dues portal is titled Over/Under (field name Dues::TotalDifference).  TotalDifference is a calculated field and it works. 

     Above Over/Under is a field called MEMBERS::SumTotalDifference which is a calculated field: sum(DUES::TotalDifference) and does NOT store the calculation results.

     The problem:  SumTotalDifference shows the correct summation of TotalDifference EXCEPT on the first record?  Huh?  And this 'weirdness' ONLY occurs on the first record? 

     Hope you can see what I apprently can not....

     Thanks

      

     Ron

total.jpg

Outcomes