Normalization with a matching Criteria

Nexgent3

Hi,

I just started using JMP. I would really appreciate your help. I wanted to normalize the Cost factor to Jan value by Product matching criteria and add it to a Norm_Cost column.

Basically Product A needs be normalized by 100 and Product B by 25. What can i enter in the formula column or a jsl script ?

 

Month	Prod	Cost	Norm_Cost
Jan	A	100	1.00
Feb	A	102	1.02
March	A	105	1.05
Jan	B	25	1.00
Feb	B	27	1.08
March	B	23	0.92

Dan_Obermiller

I'm not the best scripter, but this should work as long as your data table is sorted by Month and Prod like your example table.

dt = Current Data Table();

dt << New Column("NormCost",
			"Numeric",
		    "Continuous");

For( i=1, i <= N Rows(dt), i++,

	If (:Month[i]=="Jan",
	
	denom=:Cost[i];
	:NormCost[i]=:Cost[i]/denom,
	
	:NormCost[i]=:Cost[i]/denom
	)
)