3 Replies Latest reply on Feb 14, 2007 7:08 AM by Newsgroup_User

    Finding the average value of related structure keys

    romeogq Level 1
      Issue:
      I have a form structure which I need to find the value averages of all the *AGE keys, *MINORS keys, and *ADULTS keys.

      Here's my example form structure, after using structkeyarray() of coarse:
      1 RES_ROOM2_MINOR3_AGE
      2 RES_ROOM1_MINORS
      3 RES_ROOM2_MINOR1_AGE
      4 RES_ROOM1_MINOR2_AGE
      5 RES_ROOM3_MINOR1_AGE
      6 RES_ROOM2_MINORS
      7 RES_ROOM3_MINOR2_AGE
      8 RES_ROOM3_ADULTS
      9 RES_ROOM3_MINORS
      10 RES_ROOM1_ADULTS
      11 RES_ROOM2_ADULTS
      12 RES_ROOM1_MINOR1_AGE
      13 RES_ROOM2_MINOR2_AGE

      Question:
      How should I AT LEAST go about pulling out each set of keys so i can procede to find the mean?