Jump to content
Sign in to follow this  
sirtemplar

a script he,p! median

Recommended Posts

Will someone help me with a script? Here is what i would like to do: (database attached)

a scipt tha will:

first - sort the field FUNDS in ascending order, then

second - sum the values on field PER PeRSON until i get the equal or first greater than the value in field MIDDLE

third - copy the value of the PERPERSON on a NEW FIELD from the date where i stopped.

i hope this explains something something. to make things clearer i did it manually and from the database attached i must get this value on the NEW FIELD = 2,629 (this because on doing second above i get- 286 (greater than 284) and so i stopped at 47 and the equivalent value is 2,629.09.

thanks.

getnumber.zip

Share this post


Link to post
Share on other sites

Attached is a file set that both calculates median properly (middle number if the number of items is odd and the average of the two middle numbers if the data set number is even) for subsummary items and exports summary data to a display file.

HTH

Dave McQueen

Median.zip

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.