Compare individual value to distribution of this value (is value above avg+2*stdev)

[#1]

Hello!

I attached a sample of data structure I work with and the type of analysis I want to conduct.

Basically, I want to calculate how many values (of elements) in an given distibution exceed avg+2*stdev. I created a table chart and calculated avg and stdev. Then I typed "count(if(Cost > avg(Cost)+(stdev(Cost)*2)], Employee))" and the result is "-". I believe I mingled different levels of data aggregation ... But I dont know exactly because this is the first time I use QV.

What I know is: It seems as this cant be done in the script since the data is much more complex than my example data. Calculating avg+2*stdev in the script would require a group by clause. The result is a wide variety of scores/values.

I hope the attached file helps to understand the problem. I could provide the qvw-file if necessary - but not in public Dont hesitate to ask for more information.

Thanks in advance.

Kind regards, Daniel

[#2]

Solved it yesterday.