rocktap Posted March 6, 2003 Posted March 6, 2003 I'm using FM Pro 6 for my accounts. For budgeting I've set up Summary fields that are supposed to give me an average 'spend' in each category (eg: car, stationery etc). However these summary fields only appear to be accurate when I do a find on a single category -then the summary field for that category is accurate (and of course all the other summary fields return a zero value). Any ideas what I'm doing wrong?
Vaughan Posted March 6, 2003 Posted March 6, 2003 Summary fields work on the found set of records. To get an accurate result you need to perform a find for the right set of records.
LiveOak Posted March 6, 2003 Posted March 6, 2003 Also, if you want to define a calculation field which divides a summary field by another field, you must use the GetSummary(Summary Field, Break Field) function to "extract" the total to be used in an average from the summary field. -bd
Recommended Posts
This topic is 8036 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