269494_en-US

liliconcom

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?

 

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 checke 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"
)));

 

 

Re: 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?

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