Get Minimum on Average of 3 columns

[#1]

  Hi,

I want to get the Result2  after getting the Result1 from Data. I am able to get the Result 1. But, Could you please help me in getting the Result2 from Result1 or the Result2 from Data. Could you please send the answer to this post to email id: harvarinf1531@gmail.com

Data:
		Start Wt	OOI	2nd OOI
		39.53	28.901	28.373
		39.616	29.762	29.016
		39.064	28.075	27.761
		39.116	28.903	28.426
		39.128	28.875	28.284
		39.251	29.135	28.542
		39.373	29.441	28.822
		39.435	29.354	28.713
		39.472	28.42	28.083

Result1:
		Start Wt	OOI	2nd OOI
	Average Wt.	39.358625	28.998875	28.3755
	Stdev	0.194965153	0.551606857	0.341234314
Average Wt. +  (3 * Stdev)	+3 Sigma	39.94352046	30.65369557	29.39920294
Average Wt. -  (3 * Stdev)	-3 Sigma	38.77372954	27.34405443	27.35179706

Result2: It should be from Result1 marked in Yellow.		Expression
	Delta	Start Wt - Min( Start Wt,OOI, 2nd OOI)	OOI - Min( Start Wt,OOI, 2nd OOI)	2nd OOI - Min( Start Wt,OOI, 2nd OOI)
		10.983125	0.623375	0

[sunny_talwar]

Do you have a sample file where the data is already loaded? would be easier to help if you can share a qvw.

Best,

Sunny

[#3]

HI Sunny,

I got this requirement by using the RangeMIN function as seen below. Thanks for your immediate help when needed .

AvgWtforYMCInks:

LOAD
//RowNo()as SeqAvg,
AVG([Yellow Calculated Ink])as "YCI",
AVG([Magenta Calculated Ink]) as "MCI",

AVG([Cyan Calculated Ink]) as "CCI"

Resident CorbettSrc
where Pen_Id <> 'C5347020' ;

DeltaforYMCInks:

LOAD
Round((YCI - RangeMIN(YCI,MCI,CCI)),0.000001) as "Delta Yellow",
Round((MCI - RangeMIN(YCI,MCI,CCI)),0.000001) as "Delta Magenta",
Round((CCI - RangeMIN(YCI,MCI,CCI)),0.000001) as "Delta Cyan"

Resident AvgWtforYMCInks;
Thanks & Regards

Harish

[sunny_talwar]

Is this resolved now?

[#5]

Yes Dear Sunny. Thanks for your Response.

[sunny_talwar]

Then please close this thread by marking your own response as a correct answer.

Best,

Sunny