RET Posted August 2, 2001 Posted August 2, 2001 I have 12 different sections in my database on each section it will total up. Some of these sections may not be filled out yet. I need to create a calculation base on the number of sections that contain totals. For example section 1 has the total
Kurt Knippel Posted August 2, 2001 Posted August 2, 2001 The only way that I can think of is to have another set of fields that simply set a flag (1 or 0) on a completed "section". You then have another field which counts those flags and use that as the divisor for your averages.
RET Posted August 2, 2001 Author Posted August 2, 2001 RET I am pretty much a beginner at calculations, so could someone please give me an example on how I would write a calculation like that. Flag those fields that are not empty or have a "0" in them. Please HELP! RET
Kurt Knippel Posted August 2, 2001 Posted August 2, 2001 if ( not isempty ( TotalField1 ) ) will result in a 1 if there is something in the field, or a 0 if not. Alternately you could test for a value: if ( TotalField1 >= 1 ) which will result in a 1 if the TotalField1 is greater than or equal to 1.
Recommended Posts
This topic is 8501 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