Razzak, The column is DOUBLE. When I attempt to define a form variable using STDEV, I get the error message -ERROR- Column or variable STDEV not found (2515)
(STDEV(RepeatabilityValue)) FROM Repeatability WHERE UncertTypeAID = .vUncertTypeAID Same applies when using VAR. Jan -----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 20 Mar 2013 14:37:24 -0400 Subject: [RBASE-L] - Re: COMPUTE > At 02:25 PM 3/20/2013, Jan Johansen wrote: > > >I'm not sure if this is an issue or not. Latest 9.5 being used. > > > >In a form, I'm using form variables in the format as > >(SUM(RepeatabilityValue)) FROM Repeatability WHERE UncertTypeAID = > >.vUncertTypeAID > > > >This works with all variations of COMPUTE such as MAX and AVG. > >But it doesn't work with STDEV (standard deviation) and VAR > (variance). > > > >I need those two computations and was hoping to use form variables. > > > Jan, > > What is the data type of column RepeatabilityValue? > > > FWIW ... > > STDEV computes standard deviation for CURRENCY, DOUBLE, REAL, NUMERIC, > or INTEGER data types. > > The standard deviation is a measure of how widely values are dispersed > from the average value. > > Hope that provides you with some blue's clues! > > Very Best R:egards, > > Razzak > > www.rbase.com > www.facebook.com/rbase > >
