rob Posted December 19, 2015 Share Posted December 19, 2015 I have a summary which is "Average of Amount" which gives incorrect value so I made a new file to figure it out. In my test I have 10 records in the found set which each holds a '1' in the Amount field except for one field which is empty. The result of this summary is 1. It should be .9. In Help I search for Summary and nothing comes up. It is not listed in functions reference and I found "Summary functions" but it only lists GetSummary. Ideas what I have wrong in this summary? thank you for reading Link to comment Share on other sites More sharing options...
comment Posted December 19, 2015 Share Posted December 19, 2015 (edited) Summary fields do not count empty records (or, for the purpose of averaging, records containing non-numeric values). To force the behavior you want, use a total divided by Get (FoundCount). Edited December 19, 2015 by comment 1 Link to comment Share on other sites More sharing options...
rob Posted December 19, 2015 Author Share Posted December 19, 2015 And again, Comment, I am grateful for your help and that works. I found http://www.filemaker.com/help/11/fmp/html/create_db.8.16.html but it doesn't mention empty fields are skipped either. It seems a glaring omission. Link to comment Share on other sites More sharing options...
comment Posted December 19, 2015 Share Posted December 19, 2015 32 minutes ago, rob said: it doesn't mention empty fields are skipped Well, there is a hint in: Quote Count of Counting the number of records that contain a value for the field. But I will not argue in defense of Filemaker's help. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3044 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now