Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!tut.cis.ohio-state.edu!pt.cs.cmu.edu!cadre!pitt!unix.cis.pittsburgh.edu!rshah From: rshah@unix.cis.pittsburgh.edu (Ravindra S Shah) Newsgroups: comp.databases Subject: 1032? Summary: Routine for natural log. Message-ID: <18706@unix.cis.pittsburgh.edu> Date: 12 Jul 89 19:16:00 GMT Reply-To: rshah@unix.cis.pittsburgh.edu (Ravindra S Shah) Distribution: usa Organization: Univ. of Pittsburgh, Comp & Info Services Lines: 18 Keywords: I am currently analyzing data on our VAM/VMS using 1032 DBMS. The specific problem I have encountered is producing the geometric mean for a field in a group of records. This sounds really weird (especially since it is a breeze with my dBase III+) but 1032 does the natural log function, but doesn't have an expotential function! I have tried many ways to get a half decent result, but to no avail. To make matters worse, 1032 deosn't have the ability to perform powers (for ex. to get 3^4, a program would have a loop to multiply three times itself four times). This would be nice if the numbers I am using were integers, but they happend to be returned from the natural log function (decimals and negatives). Has anybody had to deal with a similar problem before? Any suggestions helpful. Thanks. rshah@unix.cis.pittsburgh.edu University of Pittsburgh