i have a summary total field, i want it to show a grand total. the field that i am totaling is a calculation field that equal 1 or 0. if all 3 records = 1 then the summary should read 3 on all of them. if 2 of them =1 it should read 2...etc. when one of them change the total doesn't update itself accordingly.

what could be wrong...and what could i be missing.

other info: its not a report its just a standard record view and i need a count of how many records meet the check requirements

Any chance you can provide a sample file (like attached), otherwise it's hard to determine your setup.

Sum.zip

mine is actually set up exactly like yours but my summary field doesn't update....automatically...and sorry i can't post my file right now

If(CriteriaField = "Y"; 1; 0)

In this case is it overkill:

CriteriaField = "Y" is all it takes in the calcfield, due to the way a Summary field handles null values. Chances are that empty fields otherwise would be corrupting the result.

--sd

In this case is it overkill:

CriteriaField = "Y" is all it takes in the calcfield, due to the way a Summary field handles null values. Chances are that empty fields otherwise would be corrupting the result.

--sd

Yup, it works either way. If empty fields are a concern then there is a function named IsEmpty. But we both already know that.

"In this case is it overkill" is a question "In this case it is overkill" is a statement. Do we really need to nitpick at each other?

You have to distinguise between obstructive and contructive critisism:

Kellerman posits seven "types" of bad leadership and devotes a chapter containing a few brief examples and one detailed analysis to each. Drawing from the corporate, nonprofit, government and public opinion sectors, she examines instances of incompetence, rigidity, intemperance, callousness, corruption, insularity and even evil. Her focus isn't limited to individual behavior; context and the actions of followers are also considered.

From: http://www.amazon.com/Bad-Leadership-Happens-Matters-Common/dp/1591391660

...I can't really see where you're from, but in general do european have a problem with evangelizers! ...and submissiveness to any kind of incarnation of the terra nulius myth. Just tell my why to be "follower"???

--sd

CriteriaField = "Y" is all it takes in the calcfield

but i want to add up all that = 1

i can't do a total of "Y".....can i?

Your calculation field will give 1 ( true ) even if the calc is only:

CriteriaField = "Y"

( that is what Soren wish to explain to you )

does it matter that i have the summary field placed in the body of my layout

There might something else wrong, I've just seen reluctance when the fields you summarize on are unstored calc'fields due to either globals or related records taking part of the value you summarize on.

You have a choise to make these fields straight forward stored fields, via autoenters that freshen by lifting the tag "do not replace..." - but often are we as developers reluctant to store redundant data ... and we'ed rather make it unstored anyway, and then reach out for other measures, say some scripting:

http://fmforums.com/forum/showpost.php?post/247610/

The template there, had only problems with Trailing Grand Summary to freshen accordingly, until being mended with the scripting.

--sd