Nicolas,

 

I believe part of the problem is the Trailing Grand Summary line in your
layout.  When editing an existing record or adding a new one, the
Trailing Grand Summary line is hidden.  When you click in an open space
or go to Preview mode,  the Trailing Grand Summary line reappears.  The
value is being recalculated, just not shown.   Can you move your summary
field to the body part?

 

Steve Lemond

Univ of Tennessee Martin

731-881-7895

 

From: FileMaker Pro Discussions [mailto:[log in to unmask]]
On Behalf Of Nicholas Geti
Sent: Saturday, June 05, 2010 9:01 PM
To: [log in to unmask]
Subject: How to recalculate when field changed

 

I am using FMP v5.5 in Windows XP pro.

How do I calculate the sum of a column everytime a user enters a change
anywhere in that column? The layout is in browse mode and I am using a
Trailing Grand Summary field. 

 

If I click on the Trailing field or enter Preview mode, the calculation
happens. But I would like the layout to behave like a spreadsheet where
all totals change when any item is changed.