we want to change the criteria to Actual Progress >= :Target Progress-10% compare with original Actual Progress >= :Target Progress, how to use JMP to eidit script to describe this change?

Theresa

 

Original good script:

 

 

New Column( "Target Progress",
	Numeric,
	"Continuous",
	Format( "Percent", 12, 0 ),
	Formula( :Actual Training Time / :Required Period )
);

New Column( "Meet Goal",
	"Numeric",
	formula( If( :Certified == "Y", "Yes", :Actual Progress >= :Target Progress, "Yes", "No" ) )
);

 

 

target progress is a percent, above script is workabel for old criteria of Actual Progress >= :Target Progress,
but now we want to change to actual>=(target progress-10%) then is ok. Pls check why below is not work and how to edit below?

 

 

New Column( "Target Progress", Numeric, "Continuous", Format( "Percent", 12, 0 ), Formula( :Actual Training Time / :Required Period ) );

New Column( "Meet Goal",
	"Numeric",
	formula(
		If(
			:Certified == "Y", "Yes",
			:Actual Progress >= (:Target Progress - 10%),   // this is not work
				"Yes",
			"No"
		)
	)
);

 

 

 

txnelson

I assume this is the same request as 

how to modify the script from formula(If( :Certified=="Y","Yes",:Actual Progress >= :Target Progress, to formula(If( :Certified=="Y","Yes",:Actual Progress >=( :Target Progress-10%)? 

 

That request has been responded to, so no response to this entry needs to be made.

Entering the same question multiple times is not a good practice, it creates confusion for the Discussion Community