Average and standard deviation for calculation

[#1]

Hi,

I want to calculate average and standard deviation for tha following calculation

(1- (1-sum({<Source={'MFR'}>}Process_Rejected_Parts)

can any one tell how to do that?

Thanks in Advance.

[pennetzdorfer]

Your expression lacks some brackets ... could you provide more details what you trying to calculate? Maybe an example qvw?

This recent blog post could help you Average... – Which average?

Regards,

Florian

[#3]

Hi,

I have displayed the values for the calculation

(1- (1-sum(Process_Rejected_Parts)))  against time period in chart.

and also i want to display the reference line for average of above calculated value in the same chart.

please guide.

[pennetzdorfer]

Please try the Trendline "Average" in the Expressions tab of the chart properties:

Hope that helps,

Florian

PS: I guess you could reduce your expression to sum(Process_Rejected_Parts) ...