Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generating Statistics Info
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00223474
Message ID:
00223564
Views:
26
>Bruce,
>
>Do I have your blessing?
>
>SELECT yAwrdAmt FROM cdl1 WHERE yAwrdAmt>0 ORDER BY yAwrdAmt INTO CURSOR Query
>GOTO RecCount()/2
>IF MOD(RecCount(),2)=0
> yAmt1=yAwrdAmt
> SKIP
> yAmt2=yAwrdAmt
> yAmt=(yAmt1+yAmt2)/2
>ELSE
> yAmt=yAwrdAmt
>ENDIF
>? yAmt

Looks good! And I assume you don't want to figure 0 values into this median for some reason...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform