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

thank you for helping out. but it did not work for me. i get a different value! thanks again.

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

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

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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