tmac Posted September 5, 2000 Share Posted September 5, 2000 I have 4 number fields formatted to 2 places as decimals. I want an average of these 4 fields. The trouble is not all records will have 4 entries. Some records could have as few as 2. I need it to be able to total whatever is available (2, 3 or 4 field totals) and then average using the appropriate divisor. Can it be done using calc fields or will I need to script it? Link to comment Share on other sites More sharing options...
This topic is 8225 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 account
Already have an account? Sign in here.Sign In Now