Let's say that I have a field of decimal values called Val.
How can I create a new field that categorizes any values greater than the standard deviation of Val into "1" and rest into "2"?
I tried:
IF [Val] > STDEV([Val]) THEN "1"
ElSE "2" END.
But I get an error "cannot mix aggregate and non-aggregate arguments with this function."
How can I get around this?
2 answers
Hi,
May I ask why you would compare Sum([Val]) to the STDEV([Val])?
I actually am trying to compare individual values in Val to the standard deviation.
For example, if I have values -1, 0, 1, 2 and a stdev of 0.5, then I want to -1, 0 to be "2" and 1, 2 to be "1".
I tried what you have written above and actually all of the values are categorized to "2".
TJ
